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 (gembox-spreadsheet) is a .NET component that enables developers to read, write, and convert spreadsheet files from their .NET applications.
GemBox.Spreadsheet Free is free of charge while GemBox.Spreadsheet Professional is a commercial version licensed per developer. Server deployment is royalty-free.
Support
| Read | Read & Write | Write |
|---|---|---|
| XML | XLS, XLT | PDF, PDF/A |
| XLSX, XLTX, XLSM, XLSM | XPS | |
| XLSB | PNG, JPG, GIF, BMP, TIFF | |
| ODS | ||
| CSV, TSV | ||
| HTML, MHTML | ||
| PRN, TXT |
Hello World
C#
// Create a new file.
ExcelFile workbook = new ExcelFile();
// Create a new sheet.
ExcelWorksheet worksheet = workbook.Worksheets.Add("Sheet 1");
// Get cell "A1".
ExcelCell cell = worksheet.Cells["A1"];
// Set cell value to "Hello World".
cell.Value = "Hello World";
// Save as XLSX file.
workbook.Save("Output.xlsx");
VB.NET
' Create a new file.
Dim workbook As New ExcelFile()
' Create a new sheet.
Dim worksheet As ExcelWorksheet = workbook.Worksheets.Add("Sheet 1")
' Get cell "A1".
Dim cell As ExcelCell = worksheet.Cells("A1")
' Set cell value to "Hello World".
cell.Value = "Hello World"
' Save as XLSX file.
workbook.Save("Output.xlsx")
Top Features
- Create and write Excel files in C# and VB.NET
- Create an Excel (XLSX) or PDF file in ASP.NET Core
- Create Excel Chart in C# and VB.NET
- Open and read Excel files in C# and VB.NET
- Read and write CSV (or TSV) in C# and VB.NET
- Convert Excel files to PDF in C# and VB.NET
- Convert Excel files to image formats in C# and VB.NET
- Convert Excel files to HTML in C# and VB.NET
- Print Excel files in C# and VB.NET
- Export Excel files from ASP.NET GridView
- Export a DataTable or DataSet to an Excel file in C# and VB.NET
- Export Excel sheet into DataTable in C# and VB.NET
- Import and Export Excel to DataGridView in C# and VB.NET
- Referencing Excel cell and range in C# and VB.NET
- Excel Formula Calculation in C# and VB.NET
System Requirement
- .NET Framework 3.5 - 4.8
- .NET Core 3.1 (.NET 5 & 6 for Windows)
- .NET Standard 2.0 (.NET 5 & 6 for Linux, macOS, Android, iOS, …)
Installation
You can download GemBox.Spreadsheet from NuGet
Or from BugFixes ️
