Explore the API
Charts and sparklines
Explore two worksheet charts linked to a table on Monthly data, then compare line, column, and win/loss sparklines.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
Increase January revenue by $15,000: the first column, profit point, and annual total update. Trend gallery shows line, column, and win/loss side by side.
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
Charts and sparklines
The Performance report is a normal worksheet containing two charts. Each chart series uses qualified cell references to MonthlyPerformance on a different worksheet. Beta series also receive an initial value cache; live references resolve subsequent edits without rebuilding the chart. The source table computes profit and variance with structured references. Report totals use cross-sheet formulas. The Trend gallery compares three sparkline types against the same positive and negative values.
APIs used
sheet.charts.add()
ChartSeries.values.formula
sheet.tables.add()
Table.setColumn()
sheet.addSparklines()
How to explore
Explore two worksheet charts linked to a table on Monthly data, then compare line, column, and win/loss sparklines.
Increase January revenue by $15,000: the first column, profit point, and annual total update. Trend gallery shows line, column, and win/loss side by side.
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
