Explore the API
Merge JSON into a template
Merge customer details from editable JSON into fixed workbook bindings. Repeated merges always start from the original template.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
The sheet shows the mapped customer cells. Output reports real merge warnings and formula errors.
Preparing sample...
Keep exploringReset or save
Reset restores this sample's starting document. TXWB retains its spreadsheet, dashboard, and reporting definitions.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Merge JSON into a template
Mail-merge metadata maps safe JSON property paths to template cells. createMailMergeTemplate captures a reusable template, and merge creates an independent result whose bytes are loaded into the editor.
APIs used
Workbook.setMailMerge()
Workbook.createMailMergeTemplate()
MailMergeTemplate.merge()
How to explore
Merge customer details from editable JSON into fixed workbook bindings. Repeated merges always start from the original template.
The sheet shows the mapped customer cells. Output reports real merge warnings and formula errors.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0-beta.1
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0-beta.1
