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 shift schedule. The Total column contains array formulas for calculating the total number of work hours per shift, for each employee. Modify the cell values (by adding or deleting "manager", "cashier" or "front desk"). Notice that the Total column is automatically updated.