Excel 2010/2013/2016 Features

GemBox.Spreadsheet preserves new Excel 2010/2013/2016 features like sparklines, slicers, icon sets, data bars, etc. when reading XLSX file format.

Screenshot

Excel 2010/2013 Features Screenshot

See the full code below, use RUN EXAMPLE to execute.

Upload your file (Drag files here)

1using System;
2using GemBox.Spreadsheet;
3
4class Sample
5{
6    [STAThread]
7    static void Main(string[] args)
8    {
9        // If using Professional version, put your serial key below.
10        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
11
12        ExcelFile ef = ExcelFile.Load("Excel 2010.xlsx");
13
14        // Modify all values in column C. Set them to some random value between -10 and 10.
15        var readEnumerator = ef.Worksheets[0].Columns["C"].Cells.GetReadEnumerator();
16
17        Random rnd = new Random();
18        while (readEnumerator.MoveNext())
19        {
20            ExcelCell cell = readEnumerator.Current;
21            if (cell.ValueType == CellValueType.Int)
22                cell.SetValue(rnd.Next(-10, 10));
23        }
24
25        ef.Save("Excel 2010_2013 Features.xlsx");
26    }
27}
1Imports GemBox.Spreadsheet
2
3Module Samples
4
5    Sub Main()
6
7        ' If using Professional version, put your serial key below.
8        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")
9
10        Dim ef As ExcelFile = ExcelFile.Load("Excel 2010.xlsx")
11
12        ' Modify all values in column C. Set them to some random value between -10 and 10.
13        Dim readEnumerator = ef.Worksheets(0).Columns("C").Cells.GetReadEnumerator()
14
15        Dim rnd = New Random()
16        While readEnumerator.MoveNext()
17
18            Dim cell = readEnumerator.Current
19            If cell.ValueType = CellValueType.Int Then cell.SetValue(rnd.Next(-10, 10))
20
21        End While
22
23        ef.Save("Excel 2010_2013 Features.xlsx")
24
25    End Sub
26
27End Module

Check next sample or find out more about GemBox.Spreadsheet and GemBox Software.