The following are some of the main features of Excel for UWP that you may find useful:
Excel for UWP is easy-to-use, allowing you to use a single command to load or save a workbook and manipulate sheets as if they were grid controls.
Excel for UWP works with three file formats: XLS, XLSX (OpenXML format), and CSV (comma separated values). The OpenXml format allows you to save smaller, compressed files.
After loading or creating a C1XLBook, you can access data in individual sheets as if they were a simple grid. For example:
C# Copy Code XLSheet sheet = C1XLBook.Sheets[0]; sheet[0, 0].Value = DateTime.Now;
The format associated with each cell is as easy to access as the data stored in the cell. For example:
C# Copy Code XLStyle style = new XLStyle(c1XLBook1); style.Format = "dd-MM-yyyy"; style.Font = new Font("Courier New", 14); XLSheet sheet = C1XLBook.Sheets[0]; sheet[0, 0].Value = DateTime.Now; sheet[0, 0].Style = style;
Excel for UWP fully supports cell formulas and binary parsing. The XLCell.Formula property allows you to specify a formula for the cell.
Calculate subtotals for rows and columns. Declare outline level grouping in code to best display totals and subtotals.