The DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet) 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 ASPxSpreadsheet 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.