GemBox.Spreadsheet.Examples Save

What is 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.

With GemBox.Spreadsheet you get a fast and reliable component 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 Excel files (XLSX, XLS, XLSB, ODS) files, text files (CSV, TXT), and HTML files.
• Write / create and convert to XLSX, XLS, XLSB, ODS, CSV, TXT, HTML, PDF, PDF/A, XPS, and image formats.
• View and edit spreadsheets in WPF, ASP.NET, ASP.NET Core, and Windows.Forms applications.
• Print spreadsheets or charts.
• Cell formula calculation engine.
• Protect, encrypt, and digitally sign spreadsheets.
• Get, create, or edit sheets, rows, columns, cells, formulas, hyperlinks, comments, images, charts, shapes, text boxes, tables, and pivot tables.
• Get, create, or edit cell styles and formatting, chart formatting, in-line text formatting, and conditional formatting.
• Get, create, or edit headers and footers, grouping and outlining, data validation, sheet protection, document properties, and print and view options.
• Get, create, or edit row height and column width, print titles and area, and freeze or split panes.
• Import or export spreadsheet data from/to a DataTable.
• Search, filter, or sort spreadsheet data.
• Preserve unsupported elements, including smart arts, specific charts, macros, sparklines, and slicers.

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 BugFixes 🛠️.

Resources

• Product Page
• Examples
• Documentation
• API Reference
• Forum
• Blog