GemBox.Spreadsheet is a .NET component that enables you to read, write, edit, convert, and print spreadsheet files from your .NET applications using one simple API.

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)

Download a sample file

using System;
using GemBox.Spreadsheet;

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

        ExcelFile ef = ExcelFile.Load("Excel 2010.xlsx");

        // 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 GemBox.Spreadsheet

Module Samples

    Sub Main()

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

        Dim ef As ExcelFile = ExcelFile.Load("Excel 2010.xlsx")

        ' 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 sample.