GemBox.Spreadsheet Free: Features, Limitations, and Code Examples
GemBox.Spreadsheet is a popular .NET component that allows developers to read, write, convert, and print spreadsheet files without requiring Microsoft Excel. While the company offers a commercial license, it also provides a Free version for small projects, testing, and evaluation. Key Features
The Free version contains the exact same programmatic capabilities as the professional version.
Multi-Format Support: Read and write XLSX, XLS, ODS, CSV, HTML, and TXT files.
No Excel Dependency: Runs independently of Microsoft Office or Excel installations.
Cross-Platform: Supports .NET Core, .NET Framework, .NET 6/7/8+, Mono, and Xamarin.
Advanced Formatting: Customize fonts, colors, borders, alignments, and number formatting.
Formula Engine: Supports extensive calculation formulas and cell references.
Exporting: Convert spreadsheets directly to PDF and XPS formats. Limitations of the Free Version
The only difference between the Free and Professional versions is the volume of data you can process. The Free version enforces strict performance and capacity caps.
Row/Sheet Limits: You can only read or write up to 150 rows per worksheet.
Worksheet Limits: You can only read or write up to 5 worksheets per workbook.
Enforcement Style: If your file exceeds these limits, the component throws a DeveloperException and stops execution.
No Commercial Restrictions: You can legally use the Free version in commercial applications, provided your files stay under the limits. Code Examples
To get started, install the NuGet package via your package manager console: Install-Package GemBox.Spreadsheet Use code with caution. 1. Creating and Writing a Spreadsheet
This example shows how to initialize a workbook, add data to cells, apply simple formatting, and save the file.
using GemBox.Spreadsheet; class Program { static void Main() { // Set the license key to Free SpreadsheetInfo.SetLicense(“FREE-LIMITED-KEY”); // Create a new workbook ExcelFile workbook = new ExcelFile(); ExcelWorksheet worksheet = workbook.Worksheets.Add(“Sales Data”); // Add headers worksheet.Cells[“A1”].Value = “Product”; worksheet.Cells[“B1”].Value = “Price”; worksheet.Cells[“A1”].Style.Font.Weight = ExcelFont.BoldWeight; worksheet.Cells[“B1”].Style.Font.Weight = ExcelFont.BoldWeight; // Add data (Must stay under 150 rows for the Free version) worksheet.Cells[“A2”].Value = “Laptop”; worksheet.Cells[“B2”].Value = 1200; worksheet.Cells[“A3”].Value = “Mouse”; worksheet.Cells[“B3”].Value = 25; // Save to XLSX format workbook.Save(“Sales.xlsx”); } } Use code with caution. 2. Reading an Existing Spreadsheet
This snippet demonstrates how to load a spreadsheet file and iterate through its rows and columns.
using System; using GemBox.Spreadsheet; class Program { static void Main() { SpreadsheetInfo.SetLicense(“FREE-LIMITED-KEY”); // Load the file ExcelFile workbook = ExcelFile.Load(“Sales.xlsx”); ExcelWorksheet worksheet = workbook.Worksheets[0]; // Loop through rows foreach (ExcelRow row in worksheet.Rows) { foreach (ExcelCell cell in row.AllocatedCells) { Console.Write($“{cell.Value ?? “EMPTY”} “); } Console.WriteLine(); } } } Use code with caution. 3. Converting Excel to PDF
GemBox.Spreadsheet allows you to change file formats instantly.
using GemBox.Spreadsheet; class Program { static void Main() { SpreadsheetInfo.SetLicense(“FREE-LIMITED-KEY”); // Load Excel file ExcelFile workbook = ExcelFile.Load(“Sales.xlsx”); // Save directly as PDF workbook.Save(“SalesReport.pdf”, SaveOptions.PdfDefault); } } Use code with caution. Summary: Is it right for you?
GemBox.Spreadsheet Free is an excellent choice for lightweight reporting, processing small data imports, or converting small single-page documents. If your application processes massive databases, large logs, or unpredictable user-uploaded files, you will need to upgrade to the Professional license to bypass the 150-row limit.
To help you decide if GemBox fits your technical stack, let me know:
What framework version are you targeting (e.g., .NET 8, .NET Framework 4.8)?
What is the estimated size of the files you need to process?