Key Features

The following are some of the main features of Excel for WinRT that you may find useful:

Save or load a workbook with one command

Excel for WinRT 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.

Supports CSV, XLS, and XLSX

Excel for WinRT works with three file formats: XLS, XLSX (OpenXML format), and CSV (comma separated values). The OpenXml format allows you to save smaller, compressed files.

Read and write data in individual cells

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;

C#	Copy Code
XLSheet sheet = C1XLBook.Sheets[0]; sheet[0, 0].Value = DateTime.Now;

Format the data in each cell.

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;

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;

Add Cell Formulas

Excel for WinRT fully supports cell formulas and binary parsing. The XLCell.Formula property allows you to specify a formula for the cell.

Grouping and Subtotals

Calculate subtotals for rows and columns. Declare outline level grouping in code to best display totals and subtotals.