Explore the API
Drill-down and what-if analysis
Expand regions into countries and customers, filter the overview and adjust the revenue forecast.
ResultLive API output
All examples use the same 432 orders across 2025 and 2026. Overview and order details initially show 2026. Reset restores the complete starting workbook; TXWB downloads preserve all three dashboards.
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
Drill-down and what-if analysis
Exploration changes dashboard query context without editing source cells. Expand a region in the hierarchical chart, select a customer to open Order Details, and use Back to return. The forecast parameter recalculates a measure from revenue.
APIs used
Dashboard.selectMark()
Dashboard.setFilters()
Dashboard.goBack()
Dashboard.setParameter()
How to explore
Expand regions into countries and customers, filter the overview and adjust the revenue forecast.
All examples use the same 432 orders across 2025 and 2026. Overview and order details initially show 2026. Reset restores the complete starting workbook; TXWB downloads preserve all three dashboards.
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.2
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0-beta.2
