Explore the API
Repeating rows and formulas
Merge a JSON array into a reusable invoice line band. Change the item count or quantities and merge again.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
The 18 service lines total 8005. Change the array length to see rows and formulas expand from a clean template.
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
Repeating rows and formulas
A repeat block expands a template row, maps relative item paths, and adjusts supported formulas. The total below the band sums the expanded amount column. Every run starts with clean template bytes.
APIs used
Workbook.setMailMerge()
repeatBlocks
MailMergeTemplate.merge()
How to explore
Merge a JSON array into a reusable invoice line band. Change the item count or quantities and merge again.
The 18 service lines total 8005. Change the array length to see rows and formulas expand from a clean template.
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
