Explore the API
Change cells programmatically
Update an energy reading and literal operator note, then populate a four-day forecast matrix.
ResultLive API output
B5 holds the numeric kWh reading; D5 calculates its cost. Literal text is written to A17 and the forecast matrix to A20:C24.
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
Change cells programmatically
Cell.setValue preserves numeric types; Cell.setText writes plain text. Range.setValues applies a rectangular matrix in one operation. Read back calculated values to verify updates.
APIs used
Cell.setValue()
Cell.setText()
Range.setValues()
How to explore
Update an energy reading and literal operator note, then populate a four-day forecast matrix.
B5 holds the numeric kWh reading; D5 calculates its cost. Literal text is written to A17 and the forecast matrix to A20:C24.
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
