Explore the API
Manage worksheets
Add a Summary worksheet, rename and move it, then select Sales again. Worksheet handles retain their identity while names change.
ResultLive API output
The output lists worksheet names and the selected view. Summary total references Sales!F2:F9.
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
Manage worksheets
The sheet collection creates and finds worksheets independently of the selected view. A summary formula can reference Sales. ActiveView selects a worksheet explicitly; the sample reacquires handles after reset.
APIs used
Workbook.sheets.add()
Worksheet.rename()
Worksheet.move()
Workbook.activeView
How to explore
Add a Summary worksheet, rename and move it, then select Sales again. Worksheet handles retain their identity while names change.
The output lists worksheet names and the selected view. Summary total references Sales!F2:F9.
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
