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.

Excel 2010/2013 Features Screenshot
Upload your file (Drag file here)
using System;
using GemBox.Spreadsheet;

class Program
{
    static void Main(string[] args)
    {
        // If using Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

        ExcelFile ef = ExcelFile.Load("%InputFileName%");

        // Modify all values in column C. Set them to some random value between -10 and 10.
        var readEnumerator = ef.Worksheets[0].Columns["C"].Cells.GetReadEnumerator();

        Random rnd = new Random();
        while (readEnumerator.MoveNext())
        {
            ExcelCell cell = readEnumerator.Current;
            if (cell.ValueType == CellValueType.Int)
                cell.SetValue(rnd.Next(-10, 10));
        }

        ef.Save("Excel 2010_2013 Features.xlsx");
    }
}
Imports System
Imports GemBox.Spreadsheet

Module Program

    Sub Main()

        ' If using Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

        Dim ef As ExcelFile = ExcelFile.Load("%InputFileName%")

        ' Modify all values in column C. Set them to some random value between -10 and 10.
        Dim readEnumerator = ef.Worksheets(0).Columns("C").Cells.GetReadEnumerator()

        Dim rnd = New Random()
        While readEnumerator.MoveNext()

            Dim cell = readEnumerator.Current
            If cell.ValueType = CellValueType.Int Then cell.SetValue(rnd.Next(-10, 10))

        End While

        ef.Save("Excel 2010_2013 Features.xlsx")

    End Sub

End Module

Check next example or download examples from GitHub.