This demo illustrates how to populate a worksheet programmatically based on the parameters entered into the top panel. The API of the IWorkbook object is used to create data within cells and to perform the required calculations.
In the top panel, you can change the loan characteristics. Data is automatically processed when you enter new values, and calculation results are displayed in corresponding cells.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos