Explore the API
Create a sales dashboard
Create a dashboard from the sales worksheet and inspect its KPI and regional chart. Switch back to Sales to inspect the source.
Try this workflowExplore and compare
Change the inputs, run an action, and inspect the live result below.
ResultLive API output
The KPI sums Revenue to 2,910. Output contains the actual analytics query result.
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
Create a sales dashboard
Analytics sources bind worksheet ranges with header names. A dashboard is an independent workbook view with a responsive 12-column layout. TXWB preserves its definitions and source data.
APIs used
Workbook.analytics.setSource()
Workbook.dashboards.add()
Dashboard.addWidget()
Workbook.activeView
How to explore
Create a dashboard from the sales worksheet and inspect its KPI and regional chart. Switch back to Sales to inspect the source.
The KPI sums Revenue to 2,910. Output contains the actual analytics query result.
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
