GemBox.Spreadsheet.Examples
GemBox.Spreadsheet is a .NET library that enables you to read, write, convert, and print spreadsheet files (XLSX, XLS, XLSB, CSV, HTML, and ODS) from .NET applications in a simple and efficient way.
Install / Use
/learn @GemBoxLtd/GemBox.Spreadsheet.ExamplesREADME
What is GemBox.Spreadsheet?
GemBox.Spreadsheet is a .NET library that enables you to read, write, convert, and print spreadsheet files (XLSX, XLS, XLSB, CSV, HTML, and ODS) from .NET applications.
With GemBox.Spreadsheet you get a fast and reliable library that's easy to use and doesn't depend on Microsoft Excel. It requires only .NET and it's much faster than Microsoft Office Automation!
GemBox.Spreadsheet Features
- Read XLS, XLSX, XLSB, ODS, CSV, TSV, HTML, and SpreadsheetML files.
- Create or write and convert to XLS, XLSX, XLSB, ODS, CSV, TSV, HTML, PDF, XPS, and image formats (SVG, PNG, JPEG, GIF, BMP, TIFF, WMP).
- View and edit spreadsheets in Azure Functions, Blazor, ASP.NET Core, ASP.NET, MAUI, WPF, and Windows Forms applications.
- Print spreadsheets.
- Protect, encrypt, and digitally sign spreadsheets.
- Get, create, or edit sheets, rows, columns, cells, formulas, defined names, hyperlinks, comments, tables, and pivot tables.
- Get, create, or edit drawings like shapes, images, text boxes, and charts.
- Get, create, or edit cell styles and formatting, in-line text formatting, number formatting, and conditional formatting.
- Get, create or edit headers and footers, grouping and outlining, data validation, document properties, print and view options, print titles and area, freeze or split panes, macros, and more.
- Import or export spreadsheet data from or to a DataTable.
- Find, replace, filter, sort, and autofit spreadsheet data.
- Calculate cell formulas.
- Copy sheets or cells between workbooks.
- Create or read form controls.
- Track progress or cancel long-running operations like loading and saving large spreadsheets.
- Specify fonts location when exporting to PDF, XPS, or image formats.
- Preserve unsupported elements and properties when reading a spreadsheet.
Get Started
You are not sure how to start working with Excel spreadsheets in .NET using GemBox.Spreadsheet? Check the code below that shows how to create an XLSX file from scratch and write 'Hello World!' in first cell
// If using Professional version, put your serial key below.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
// Create a new empty workbook.
var workbook = new ExcelFile();
// Add a worksheet to it.
var worksheet = workbook.Worksheets.Add("Sheet1");
// Write to the first cell.
worksheet.Cells["A1"].Value = "Hello World!";
// Save the workbook as Excel's XLSX file.
workbook.Save("Writing.xlsx");
For more GemBox.Spreadsheet code examples and demos, please visit our examples page.
Installation
You can download GemBox.Spreadsheet from NuGet 📦 or from Downloads 🛠️.
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.
