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.