Getting started with GemBox.Spreadsheet

GemBox.Spreadsheet is a .NET component that enables you to read, write, convert, and print spreadsheet files (XLSX, XLS, XLSB, CSV, HTML, and ODS) from .NET applications.


GemBox.Spreadsheet requires only .NET. It supports a wide range of .NET versions, as listed below:

  • .NET 6.0+ (Windows only)
  • .NET Standard 2.0+ (Android, iOS, Linux, macOS, Windows)
  • .NET Framework 3.5+ (Windows only)


Before you can use GemBox.Spreadsheet, you need to install it in your project. The best way is by adding a GemBox.Spreadsheet NuGet package via NuGet Package Manager in Visual Studio.

To install the package, you can follow the steps listed below. However, please note that this guide assumes you have already set up a Visual Studio project. If you haven't done that yet, you can refer to the official tutorial for guidance.

  1. Right-click on the project's solution in the Solution Explorer and select 'Manage NuGet Packages for Solution'.
    Manage NuGet Packages
  2. On the newly opened view, click the 'Browse' tab and search for GemBox.Spreadsheet. Once found, click on 'Install'.
    Install GemBox.Spreadsheet NuGet package
  3. That is it. Once the installation finishes, you will be able to use the component in your code.

As an alternative, you can open the NuGet Package Manager Console (Tools -> NuGet Package Manager -> Package Manager Console) and run the following command:

Install-Package GemBox.Spreadsheet

We also provide DLL and setup downloads on GemBox.Spreadsheet's BugFixes page. Setup download links are at the bottom of the page, under the 'Global Assembly' section.


Once you have installed GemBox.Spreadsheet, all you have to do is add the using directive and make sure you call the SpreadsheetInfo.SetLicense method before using any member of the component. We suggest putting the call at the beginning of the Main() method.

The SpreadsheetInfo.SetLicense requires a license key as a parameter. If you are using the component in a Free mode, use "FREE-LIMITED-KEY" as a license key, and if you have purchased a Professional license, use the key you got in your email after the purchase. You can read more about GemBox.Spreadsheet's working modes on the Evaluation and Licensing page.

After that, you can write your application code for working with spreadsheets, like the code below. It shows how to create a simple Excel workbook using GemBox.Spreadsheet's content model, add an ExcelWorksheet, populate cells using ExcelCell, and then save the ExcelFile to an XLSX file.

You can click the 'Run Example' button to run the code and download the resulting file. You can also change the output format by selecting a corresponding file type from the 'Output file type' dropdown control.

using GemBox.Spreadsheet;

class Program
    static void Main()
        // If using the Professional version, put your serial key below.

        ExcelFile workbook = new ExcelFile();
        ExcelWorksheet worksheet = workbook.Worksheets.Add("Sheet1");
        ExcelCell cell = worksheet.Cells["A1"];

        cell.Value = "Hello World!";

Imports GemBox.Spreadsheet

Module Program

    Sub Main()

        ' If using the Professional version, put your serial key below.

        Dim workbook As New ExcelFile()
        Dim worksheet As ExcelWorksheet = workbook.Worksheets.Add("Sheet1")
        Dim cell As ExcelCell = worksheet.Cells("A1")

        cell.Value = "Hello World!"


    End Sub

End Module
Screenshot of an Excel file created with GemBox.Spreadsheet
Screenshot of an Excel file created with GemBox.Spreadsheet

To learn more about GemBox.Spreadsheet, check out our collection of examples listed on the menu. These examples will show you how to use the component in various spreadsheet-processing tasks and platforms. Additionally, for detailed information on the API, head to our documentation pages. This resource offers a comprehensive API reference, explaining each method and property available within the component.

See also

Next steps

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.

Download Buy