GemBox.Spreadsheet Free Version

Limitations

Free delivers the same performance and set of features as the Professional version. However, the following limitations are imposed during reading or writing files:

• Maximum number of rows per sheet is 150.
• Maximum number of sheets per workbook is 5.

The SpreadsheetInfo.FreeLimitReached event allows you to control what happens when your application reaches the free version limit. You can use this event to continue using the assembly in Trial mode for performance testing or to stop further reading/writing.

First steps

Using the library is easy and straightforward. After referencing .dll from your project, you can use the following code snippet to generate a simple Excel file:

C# VB.NET

static void Main()
{
    // Set license key to use GemBox.Spreadsheet in Free mode.
    SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

    // Create a new empty Excel file.
    var workbook = new ExcelFile();

    // Create a new worksheet and set cell A1 value to 'Hello world!'.
    workbook.Worksheets.Add("Sheet 1").Cells["A1"].Value = "Hello world!";

    // Save to XLSX file.
    workbook.Save("Spreadsheet.xlsx");
}

Sub Main()
    ' Set license key to use GemBox.Spreadsheet in Free mode.
    SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

    ' Create a new empty Excel file.
    Dim workbook = New ExcelFile()

    ' Create a new worksheet and set cell A1 value to 'Hello world!'.
    workbook.Worksheets.Add("Sheet 1").Cells("A1").Value = "Hello world!"

    ' Save to XLSX file sdfsf.
    workbook.Save("Spreadsheet.xlsx")
End Sub

AI coding

CLI coding agents such as GitHub Copilot, Claude Code, and OpenAI Codex can write valid GemBox code when enabled with our gembox-skill.

Usage

You can use GemBox.Spreadsheet Free for any purpose, including use in commercial applications.

GemBox is under no obligation to provide technical or any other support to the users of the free version.