The DevExpress ASP.NET MVC Spreadsheet can load a wide variety of formatted Excel documents. The spreadsheet documents used in this demo section are based on popular Microsoft Excel templates that you can download from Microsoft’s Templates for Excel page.
In this demo, the Spreadsheet programmatically opens an XLSX document representing a loan amortization schedule. Change the values of the fields above the table (Loan amount, Annual interest rate, Loan period in years, Number of payments per year, etc.). Notice that the loan schedule is updated automatically, and the table below is recalculated.
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