GemBox.Spreadsheet 49.0.1202
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.
Resources
No packages depend on GemBox.Spreadsheet.
- Added partial support for LINEST function.
- Added support for NUMBERVALUE, UNICODE and TRANSPOSE functions.
- Added support for FORECAST and FORECAST.LINEAR functions.
- Fixed issue with chart titles that have newlines in XLSX reader.
- Fixed issue with converting from A1 to R1C1 notation.
- Fixed issue with TextField elements that have newlines in XLSX reader.
- Added support for PEARSON and RSQ functions.
- Added support for PivotTable.DataRange property.
- Fixed issue with missing font record in XLS reader.
- Fixed issue with ignored casing when validating list DataValidation.
- Added support for macros with ExcelFile.VbaProject.
- Fixed issue with PivotTable location in XLSX files.
- Fixed issue with losing filter on Table when rows/columns are inserted/removed.
.NET Framework 3.5
- BouncyCastle (>= 1.8.9)
.NET Core 3.1
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.80.3)
- System.Text.Encoding.CodePages (>= 5.0.0)
.NET Standard 2.0
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.80.3)
- System.Text.Encoding.CodePages (>= 5.0.0)
| Version | Downloads | Last updated |
|---|---|---|
| 2025.12.105 | 1 | 18.12.2025 |
| 2025.11.106 | 4 | 10.11.2025 |
| 2025.10.102 | 8 | 25.10.2025 |
| 2025.9.107 | 8 | 16.09.2025 |
| 2025.8.116 | 13 | 31.08.2025 |
| 2025.7.101 | 9 | 16.09.2025 |
| 2025.6.110 | 8 | 16.09.2025 |
| 2025.5.104 | 10 | 16.09.2025 |
| 2025.4.107 | 4 | 16.09.2025 |
| 2025.3.112 | 4 | 16.09.2025 |
| 2025.2.109 | 4 | 16.09.2025 |
| 2025.1.104 | 7 | 16.09.2025 |
| 49.0.1895 | 4 | 16.09.2025 |
| 49.0.1858 | 4 | 16.09.2025 |
| 49.0.1839 | 4 | 16.09.2025 |
| 49.0.1822 | 6 | 16.09.2025 |
| 49.0.1799 | 4 | 16.09.2025 |
| 49.0.1767 | 11 | 16.09.2025 |
| 49.0.1737 | 4 | 16.09.2025 |
| 49.0.1697 | 8 | 16.09.2025 |
| 49.0.1655 | 7 | 16.09.2025 |
| 49.0.1623 | 4 | 16.09.2025 |
| 49.0.1612 | 4 | 16.09.2025 |
| 49.0.1586 | 4 | 16.09.2025 |
| 49.0.1562 | 9 | 16.09.2025 |
| 49.0.1542 | 4 | 16.09.2025 |
| 49.0.1509 | 11 | 16.09.2025 |
| 49.0.1454 | 4 | 16.09.2025 |
| 49.0.1423 | 13 | 16.09.2025 |
| 49.0.1398 | 4 | 16.09.2025 |
| 49.0.1379 | 7 | 16.09.2025 |
| 49.0.1335 | 4 | 16.09.2025 |
| 49.0.1301 | 4 | 16.09.2025 |
| 49.0.1274 | 4 | 16.09.2025 |
| 49.0.1244 | 4 | 16.09.2025 |
| 49.0.1225 | 9 | 16.09.2025 |
| 49.0.1202 | 11 | 16.09.2025 |
| 49.0.1153 | 10 | 16.09.2025 |
| 49.0.1127 | 7 | 16.09.2025 |
| 49.0.1103 | 12 | 16.09.2025 |
| 49.0.1084 | 4 | 16.09.2025 |
| 49.0.1067 | 14 | 16.09.2025 |
| 49.0.1039 | 8 | 16.09.2025 |
| 49.0.1017 | 6 | 16.09.2025 |
| 49.0.1000 | 4 | 16.09.2025 |
| 47.0.1418 | 11 | 16.09.2025 |
| 47.0.1398 | 10 | 16.09.2025 |
| 47.0.1363 | 10 | 16.09.2025 |
| 47.0.1345 | 4 | 16.09.2025 |
| 47.0.1321 | 10 | 16.09.2025 |
| 47.0.1298 | 10 | 16.09.2025 |
| 47.0.1268 | 4 | 16.09.2025 |
| 47.0.1248 | 9 | 16.09.2025 |
| 47.0.1230 | 4 | 16.09.2025 |
| 47.0.1207 | 10 | 16.09.2025 |
| 47.0.1170 | 4 | 16.09.2025 |
| 47.0.1129 | 4 | 16.09.2025 |
| 47.0.1095 | 8 | 16.09.2025 |
| 47.0.1071 | 6 | 16.09.2025 |
| 47.0.1069 | 10 | 16.09.2025 |
| 47.0.1044 | 9 | 16.09.2025 |
| 47.0.1029 | 9 | 16.09.2025 |
| 47.0.1013 | 9 | 16.09.2025 |
| 47.0.1000 | 11 | 16.09.2025 |
| 45.0.1225 | 4 | 16.09.2025 |
| 45.0.1206 | 7 | 16.09.2025 |
| 45.0.1187 | 8 | 16.09.2025 |
| 45.0.1176 | 4 | 16.09.2025 |
| 45.0.1148 | 4 | 16.09.2025 |
| 45.0.1131 | 7 | 16.09.2025 |
| 45.0.0.1094 | 7 | 16.09.2025 |
| 45.0.0.1084 | 4 | 16.09.2025 |
| 45.0.0.1069 | 7 | 16.09.2025 |
| 45.0.0.1061 | 4 | 16.09.2025 |
| 45.0.0.1060 | 4 | 16.09.2025 |
| 45.0.0.1043 | 4 | 16.09.2025 |
| 45.0.0.1040 | 6 | 16.09.2025 |
| 45.0.0.1019 | 4 | 16.09.2025 |
| 45.0.0.1010 | 4 | 16.09.2025 |
| 45.0.0.1000 | 7 | 16.09.2025 |
| 43.0.0.1140 | 6 | 16.09.2025 |
| 43.0.0.1139 | 6 | 16.09.2025 |
| 43.0.0.1127 | 5 | 16.09.2025 |
| 43.0.0.1115 | 6 | 16.09.2025 |
| 43.0.0.1111 | 4 | 16.09.2025 |
| 43.0.0.1106 | 4 | 16.09.2025 |
| 43.0.0.1095 | 4 | 16.09.2025 |
| 43.0.0.1084 | 5 | 16.09.2025 |
| 43.0.0.1076 | 6 | 16.09.2025 |
| 43.0.0.1066 | 6 | 16.09.2025 |
| 43.0.0.1049 | 4 | 16.09.2025 |
| 43.0.0.1036 | 5 | 16.09.2025 |
| 43.0.0.1020 | 5 | 16.09.2025 |
| 43.0.0.1005 | 4 | 16.09.2025 |
| 43.0.0.1000 | 5 | 16.09.2025 |
| 41.3.30.1183 | 6 | 16.09.2025 |
| 41.3.30.1181 | 4 | 16.09.2025 |
| 41.3.30.1179 | 5 | 16.09.2025 |
| 41.3.30.1177 | 6 | 16.09.2025 |
| 41.3.30.1173 | 7 | 16.09.2025 |
| 41.3.30.1169 | 6 | 16.09.2025 |
| 41.3.30.1168 | 7 | 16.09.2025 |
| 41.3.30.1165 | 6 | 16.09.2025 |
| 41.3.30.1158 | 5 | 16.09.2025 |
| 41.3.30.1154 | 4 | 16.09.2025 |
| 41.3.30.1147 | 8 | 16.09.2025 |
| 41.3.30.1136 | 5 | 16.09.2025 |
| 41.3.30.1132 | 5 | 16.09.2025 |
| 41.3.30.1128 | 4 | 16.09.2025 |
| 41.3.30.1122 | 7 | 16.09.2025 |
| 41.3.30.1111 | 6 | 16.09.2025 |
| 41.3.30.1106 | 6 | 16.09.2025 |
| 41.3.30.1101 | 4 | 16.09.2025 |
| 41.3.30.1091 | 8 | 16.09.2025 |
| 41.3.30.1070 | 4 | 16.09.2025 |
| 41.3.30.1059 | 4 | 16.09.2025 |
| 41.3.30.1047 | 5 | 16.09.2025 |
| 41.3.30.1038 | 4 | 16.09.2025 |
| 41.3.30.1033 | 6 | 16.09.2025 |
| 41.3.30.1032 | 4 | 16.09.2025 |
| 41.3.30.1018 | 4 | 16.09.2025 |
| 41.3.30.1000 | 5 | 16.09.2025 |
| 39.3.30.1215 | 8 | 16.09.2025 |
| 39.3.30.1214 | 4 | 16.09.2025 |
| 39.3.30.1213 | 4 | 16.09.2025 |
| 39.3.30.1212 | 4 | 16.09.2025 |
| 39.3.30.1211 | 5 | 16.09.2025 |
| 39.3.30.1207 | 4 | 16.09.2025 |
| 39.3.30.1205 | 7 | 16.09.2025 |
| 39.3.30.1202 | 6 | 16.09.2025 |
| 39.3.30.1198 | 5 | 16.09.2025 |
| 39.3.30.1189 | 7 | 16.09.2025 |
| 39.3.30.1171 | 4 | 16.09.2025 |
| 39.3.30.1163 | 4 | 16.09.2025 |
| 39.3.30.1153 | 7 | 16.09.2025 |
| 39.3.30.1140 | 5 | 16.09.2025 |
| 39.3.30.1132 | 9 | 16.09.2025 |
| 39.3.30.1130 | 4 | 16.09.2025 |
| 39.3.30.1129 | 4 | 16.09.2025 |
| 39.3.30.1128 | 5 | 16.09.2025 |
| 39.3.30.1125 | 5 | 16.09.2025 |
| 39.3.30.1119 | 4 | 16.09.2025 |
| 39.3.30.1106 | 8 | 16.09.2025 |
| 39.3.30.1095 | 7 | 16.09.2025 |
| 39.3.30.1077 | 7 | 16.09.2025 |
| 39.3.30.1063 | 4 | 16.09.2025 |
| 39.3.30.1048 | 7 | 16.09.2025 |
| 39.3.30.1037 | 6 | 16.09.2025 |
| 39.3.30.1024 | 5 | 16.09.2025 |
| 39.3.30.1007 | 4 | 16.09.2025 |
| 39.3.30.1000 | 4 | 16.09.2025 |
| 37.3.30.1189 | 4 | 16.09.2025 |
| 37.3.30.1188 | 4 | 16.09.2025 |
| 37.3.30.1185 | 6 | 16.09.2025 |
| 37.3.30.1183 | 5 | 16.09.2025 |
| 37.3.30.1182 | 4 | 16.09.2025 |
| 37.3.30.1179 | 7 | 16.09.2025 |
| 37.3.30.1176 | 6 | 16.09.2025 |
| 37.3.30.1165 | 5 | 16.09.2025 |
| 37.3.30.1160 | 7 | 16.09.2025 |
| 37.3.30.1128 | 4 | 16.09.2025 |
| 37.3.30.1120 | 4 | 16.09.2025 |
| 37.3.30.1110 | 4 | 16.09.2025 |
| 37.3.30.1099 | 8 | 16.09.2025 |
| 37.3.30.1088 | 5 | 16.09.2025 |
| 37.3.30.1069 | 4 | 16.09.2025 |
| 37.3.30.1030 | 5 | 16.09.2025 |
| 37.3.30.1000 | 4 | 16.09.2025 |