Explore the API
Excel-style tables
Turn 24 equipment orders into a structured table, then fill three empty calculated columns and change an order quantity.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
Watch the empty yellow Net / Tax / Total columns fill for all 24 orders. Output includes the first formula, calculated totals, and the grand total.
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
Excel-style tables
OrderBook starts with empty Net, Tax, and Total columns highlighted in pale yellow. Table.setColumn installs structured formulas that populate every data row. Net accounts for the line discount; Tax and Total depend on other calculated columns. The first order is two $489 displays, so its calculated total is $1,163.82. Increasing the quantity by three updates it to $2,909.55.
APIs used
sheet.tables.add()
Table.setColumn()
Table.update()
Workbook.calculation.recalculateAsync()
How to explore
Turn 24 equipment orders into a structured table, then fill three empty calculated columns and change an order quantity.
Watch the empty yellow Net / Tax / Total columns fill for all 24 orders. Output includes the first formula, calculated totals, and the grand total.
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
