ComponentOne Excel for UWP
In This Topic
    Key Features
    In This Topic

    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.

    See Also