GemBox.Spreadsheet
49.0.1202
Prefix Reserved
See the version list below for details.
dotnet add package GemBox.Spreadsheet --version 49.0.1202
NuGet\Install-Package GemBox.Spreadsheet -Version 49.0.1202
<PackageReference Include="GemBox.Spreadsheet" Version="49.0.1202" />
paket add GemBox.Spreadsheet --version 49.0.1202
#r "nuget: GemBox.Spreadsheet, 49.0.1202"
// Install GemBox.Spreadsheet as a Cake Addin #addin nuget:?package=GemBox.Spreadsheet&version=49.0.1202 // Install GemBox.Spreadsheet as a Cake Tool #tool nuget:?package=GemBox.Spreadsheet&version=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
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. 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 is compatible. |
.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 was computed. 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. |
-
.NETCoreApp 3.1
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.80.3)
- System.Text.Encoding.CodePages (>= 5.0.0)
-
.NETFramework 3.5
- BouncyCastle (>= 1.8.9)
-
.NETStandard 2.0
- HarfBuzzSharp (>= 2.8.2)
- Portable.BouncyCastle (>= 1.8.9)
- SkiaSharp (>= 2.80.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 |
- 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.