GemBox.Spreadsheet
49.0.1379
Prefix Reserved
See the version list below for details.
dotnet add package GemBox.Spreadsheet --version 49.0.1379
NuGet\Install-Package GemBox.Spreadsheet -Version 49.0.1379
<PackageReference Include="GemBox.Spreadsheet" Version="49.0.1379" />
paket add GemBox.Spreadsheet --version 49.0.1379
#r "nuget: GemBox.Spreadsheet, 49.0.1379"
// Install GemBox.Spreadsheet as a Cake Addin #addin nuget:?package=GemBox.Spreadsheet&version=49.0.1379 // Install GemBox.Spreadsheet as a Cake Tool #tool nuget:?package=GemBox.Spreadsheet&version=49.0.1379
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 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.
Resources
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net6.0-windows7.0 is compatible. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net35 is compatible. net40 was computed. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 is compatible. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 3.5
- BouncyCastle (>= 1.8.9)
-
.NETFramework 4.6.1
- Portable.BouncyCastle (>= 1.8.9)
-
.NETStandard 2.0
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.88.3)
- System.Reflection.Emit.ILGeneration (>= 4.7.0)
- System.Reflection.Emit.Lightweight (>= 4.7.0)
- System.Text.Encoding.CodePages (>= 5.0.0)
-
net6.0-windows7.0
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.88.3)
- System.Text.Encoding.CodePages (>= 5.0.0)
NuGet packages (12)
Showing the top 5 NuGet packages that depend on GemBox.Spreadsheet:
Package | Downloads |
---|---|
GemBox.Bundle
GemBox.Bundle is a package of .NET components for processing spreadsheets, documents, presentations, email messages, and images (XLSX, DOCX, PPTX, PDF, MSG, and PNG) from .NET applications. With GemBox.Bundle you get fast and reliable components that are easy to use and don't depend on Microsoft Office or Adobe Acrobat. They require only .NET so you can deploy your applications without having to think about other licenses. |
|
GemBox.Spreadsheet.WinFormsUtilities
GemBox.Spreadsheet.WinFormsUtilities is a utility component for GemBox.Spreadsheet that enables developers to import/export DataGridView control to/from Excel file. |
|
SymphonyFramework4
Symphony Framework is a true cross-platform framework which provides the ability to enhance and develop applications to meet the growing needs of users and businesses. |
|
bict-SibaLife
SibaCore is a multipurpose framework built for the perculiar needs of BIC Technologies and seeks to make working with a data layer as easy as possible. With the help of our custom built generic repository, all CRUD functionalities are abtracted away from the programmer to reduce repetitive code. SibaCore also supports generic API's which intergrate with our custom generic repositories to provide a bare bone API taking away the need for the programmer to specify CRUD API end points; this allows you to focus on other important API end points for your application. SibaCore also includes utility methods which simplify tasks such as reading and writing data in excel peforming deep and shallow mapping between objects of any types and many more. This version of SibaCore has been modified to work with the SibaLife application. |
|
Zapos.Printers.Gembox
Printer.Gembox - small part of Zapos, responsible for converting report from abstract document model. Supports file formats: XLSX (XlsxPrinter) and PDF (PdfPrinter). |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
49.0.1858 | 6,887 | 11/4/2024 |
49.0.1839 | 22,439 | 10/8/2024 |
49.0.1822 | 29,665 | 9/5/2024 |
49.0.1799 | 22,410 | 8/13/2024 |
49.0.1767 | 26,908 | 7/5/2024 |
49.0.1737 | 30,418 | 6/7/2024 |
49.0.1697 | 51,299 | 5/7/2024 |
49.0.1655 | 44,142 | 4/6/2024 |
49.0.1623 | 36,812 | 3/4/2024 |
49.0.1612 | 26,525 | 2/13/2024 |
49.0.1586 | 40,392 | 1/15/2024 |
49.0.1562 | 230,889 | 12/8/2023 |
49.0.1542 | 58,547 | 11/16/2023 |
49.0.1509 | 171,146 | 10/21/2023 |
49.0.1454 | 178,412 | 9/5/2023 |
49.0.1423 | 36,442 | 8/4/2023 |
49.0.1398 | 116,161 | 7/7/2023 |
49.0.1379 | 62,383 | 6/12/2023 |
49.0.1335 | 123,322 | 5/10/2023 |
49.0.1301 | 37,380 | 4/5/2023 |
49.0.1274 | 65,762 | 3/10/2023 |
49.0.1244 | 111,607 | 2/3/2023 |
49.0.1225 | 80,173 | 1/3/2023 |
49.0.1202 | 177,207 | 12/14/2022 |
49.0.1153 | 53,940 | 11/9/2022 |
49.0.1127 | 129,540 | 10/12/2022 |
49.0.1103 | 51,254 | 9/6/2022 |
49.0.1084 | 103,953 | 8/12/2022 |
49.0.1067 | 46,334 | 7/21/2022 |
49.0.1039 | 47,688 | 6/10/2022 |
49.0.1017 | 74,562 | 5/16/2022 |
49.0.1000 | 49,096 | 4/21/2022 |
47.0.1418 | 173,538 | 3/9/2022 |
47.0.1398 | 109,717 | 2/1/2022 |
47.0.1363 | 33,747 | 1/5/2022 |
47.0.1345 | 143,494 | 12/7/2021 |
47.0.1321 | 125,706 | 11/5/2021 |
47.0.1298 | 51,149 | 10/1/2021 |
47.0.1268 | 88,722 | 8/26/2021 |
47.0.1248 | 294,340 | 7/14/2021 |
47.0.1230 | 56,044 | 6/17/2021 |
47.0.1207 | 40,163 | 5/14/2021 |
47.0.1170 | 63,488 | 4/20/2021 |
47.0.1129 | 125,846 | 3/9/2021 |
47.0.1095 | 68,753 | 2/3/2021 |
47.0.1071 | 18,011 | 1/13/2021 |
47.0.1069 | 6,490 | 1/12/2021 |
47.0.1044 | 130,730 | 12/2/2020 |
47.0.1029 | 19,040 | 11/9/2020 |
47.0.1013 | 13,880 | 10/16/2020 |
47.0.1000 | 50,446 | 9/16/2020 |
45.0.1225 | 205,211 | 9/8/2020 |
45.0.1206 | 34,200 | 8/6/2020 |
45.0.1187 | 27,508 | 6/26/2020 |
45.0.1176 | 125,164 | 5/22/2020 |
45.0.1148 | 56,529 | 4/9/2020 |
45.0.1131 | 55,208 | 3/16/2020 |
45.0.0.1094 | 30,607 | 2/10/2020 |
45.0.0.1084 | 42,143 | 1/8/2020 |
45.0.0.1069 | 20,816 | 12/3/2019 |
45.0.0.1061 | 17,517 | 11/6/2019 |
45.0.0.1060 | 5,978 | 10/31/2019 |
45.0.0.1043 | 31,942 | 9/27/2019 |
45.0.0.1040 | 4,428 | 9/20/2019 |
45.0.0.1019 | 35,757 | 8/8/2019 |
45.0.0.1010 | 7,068 | 7/12/2019 |
45.0.0.1000 | 48,217 | 6/4/2019 |
43.0.0.1140 | 214,715 | 1/14/2020 |
43.0.0.1139 | 10,644 | 9/20/2019 |
43.0.0.1127 | 28,540 | 5/8/2019 |
43.0.0.1115 | 43,480 | 4/9/2019 |
43.0.0.1111 | 24,354 | 2/26/2019 |
43.0.0.1106 | 63,999 | 2/5/2019 |
43.0.0.1095 | 7,993 | 1/2/2019 |
43.0.0.1084 | 42,517 | 11/8/2018 |
43.0.0.1076 | 19,937 | 9/25/2018 |
43.0.0.1066 | 10,238 | 8/23/2018 |
43.0.0.1049 | 19,338 | 7/16/2018 |
43.0.0.1036 | 34,154 | 6/8/2018 |
43.0.0.1020 | 35,367 | 5/4/2018 |
43.0.0.1005 | 15,602 | 4/4/2018 |
43.0.0.1000 | 12,923 | 3/27/2018 |
41.3.30.1183 | 67,649 | 7/2/2019 |
41.3.30.1181 | 12,007 | 5/6/2019 |
41.3.30.1179 | 35,249 | 2/4/2019 |
41.3.30.1177 | 5,754 | 11/8/2018 |
41.3.30.1173 | 26,310 | 9/25/2018 |
41.3.30.1169 | 9,655 | 8/23/2018 |
41.3.30.1168 | 33,864 | 7/16/2018 |
41.3.30.1165 | 611,126 | 6/8/2018 |
41.3.30.1158 | 4,653 | 5/4/2018 |
41.3.30.1154 | 509,056 | 4/4/2018 |
41.3.30.1147 | 11,104 | 2/22/2018 |
41.3.30.1136 | 17,019 | 1/11/2018 |
41.3.30.1132 | 13,175 | 12/8/2017 |
41.3.30.1128 | 8,998 | 11/13/2017 |
41.3.30.1122 | 10,265 | 10/11/2017 |
41.3.30.1111 | 106,332 | 9/12/2017 |
41.3.30.1106 | 26,924 | 8/16/2017 |
41.3.30.1101 | 1,015,269 | 7/7/2017 |
41.3.30.1091 | 9,773 | 6/2/2017 |
41.3.30.1070 | 39,286 | 3/21/2017 |
41.3.30.1059 | 14,023 | 2/17/2017 |
41.3.30.1047 | 6,849 | 1/21/2017 |
41.3.30.1038 | 6,178 | 12/23/2016 |
41.3.30.1033 | 4,785 | 12/9/2016 |
41.3.30.1032 | 2,764 | 12/6/2016 |
41.3.30.1018 | 13,821 | 11/8/2016 |
41.3.30.1000 | 6,888 | 9/27/2016 |
39.3.30.1215 | 116,806 | 3/26/2018 |
39.3.30.1214 | 24,298 | 12/8/2017 |
39.3.30.1213 | 5,098 | 11/13/2017 |
39.3.30.1212 | 5,246 | 8/16/2017 |
39.3.30.1211 | 12,794 | 6/2/2017 |
39.3.30.1207 | 5,786 | 2/17/2017 |
39.3.30.1205 | 5,578 | 1/20/2017 |
39.3.30.1202 | 10,645 | 11/7/2016 |
39.3.30.1198 | 6,814 | 9/26/2016 |
39.3.30.1189 | 120,553 | 8/18/2016 |
39.3.30.1171 | 28,910 | 6/14/2016 |
39.3.30.1163 | 10,696 | 5/11/2016 |
39.3.30.1153 | 13,450 | 4/4/2016 |
39.3.30.1140 | 15,937 | 2/25/2016 |
39.3.30.1132 | 4,922 | 2/15/2016 |
39.3.30.1130 | 24,187 | 2/1/2016 |
39.3.30.1129 | 3,668 | 1/19/2016 |
39.3.30.1128 | 2,658 | 1/17/2016 |
39.3.30.1125 | 6,348 | 12/10/2015 |
39.3.30.1119 | 6,988 | 11/25/2015 |
39.3.30.1106 | 26,734 | 10/6/2015 |
39.3.30.1095 | 13,479 | 9/1/2015 |
39.3.30.1077 | 23,620 | 7/3/2015 |
39.3.30.1063 | 18,524 | 5/28/2015 |
39.3.30.1048 | 6,606 | 4/21/2015 |
39.3.30.1037 | 23,887 | 3/17/2015 |
39.3.30.1024 | 4,859 | 2/17/2015 |
39.3.30.1007 | 5,237 | 1/14/2015 |
39.3.30.1000 | 10,003 | 12/24/2014 |
37.3.30.1189 | 132,138 | 9/26/2016 |
37.3.30.1188 | 2,789 | 8/18/2016 |
37.3.30.1185 | 9,849 | 4/4/2016 |
37.3.30.1183 | 14,984 | 2/1/2016 |
37.3.30.1182 | 4,634 | 11/25/2015 |
37.3.30.1179 | 2,883 | 10/6/2015 |
37.3.30.1176 | 5,970 | 3/16/2015 |
37.3.30.1165 | 6,690 | 12/5/2014 |
37.3.30.1160 | 15,789 | 10/14/2014 |
37.3.30.1128 | 75,651 | 6/12/2014 |
37.3.30.1120 | 4,925 | 4/30/2014 |
37.3.30.1110 | 10,624 | 2/13/2014 |
37.3.30.1099 | 4,897 | 11/26/2013 |
37.3.30.1088 | 7,662 | 9/9/2013 |
37.3.30.1069 | 6,003 | 6/13/2013 |
37.3.30.1030 | 11,703 | 3/14/2013 |
37.3.30.1000 | 29,975 | 2/6/2013 |
Fixed issue with metadata in XLSX writer.
Fixed issue with references mapping in array functions.
Fixed issue with VLOOKUP function calculation.
Fixed issue with emtpy text in NUMBERVALUE function.
Fixed issue with wrong chart plot area color in PDF writer.
Added support for preserving hidden defined names.
Fixed issue with INDIRECT function calculation.
Fixed issue with ROUNDUP and ROUNDDOWN precision.
Added support for ExcelFormControl.FormControlType.
Fixed issue with cell wrapping and column width in HTML reader.
Added support for ExcelDrawingMetadata.Description and ExcelDrawingMetadata.Title.
Added support for chart secondary axis.
Fixed issue with PRODUCT function calculation.
Added support for exteranal link in XLSB reader.