GrapeCity.Documents.Excel
7.2.0
See the version list below for details.
dotnet add package GrapeCity.Documents.Excel --version 7.2.0
NuGet\Install-Package GrapeCity.Documents.Excel -Version 7.2.0
<PackageReference Include="GrapeCity.Documents.Excel" Version="7.2.0" />
paket add GrapeCity.Documents.Excel --version 7.2.0
#r "nuget: GrapeCity.Documents.Excel, 7.2.0"
// Install GrapeCity.Documents.Excel as a Cake Addin #addin nuget:?package=GrapeCity.Documents.Excel&version=7.2.0 // Install GrapeCity.Documents.Excel as a Cake Tool #tool nuget:?package=GrapeCity.Documents.Excel&version=7.2.0
GrapeCity Documents for Excel
Please refer to the note below for important package information.
Programmatically create Excel .xlsx spreadsheets with ease in your server or desktop applications. GrapeCity Documents for Excel (GcExcel) is a cross-platform high-speed, small-footprint spreadsheet API library that requires no dependencies on Excel. With full .NET 6 support, you can programmatically generate, load, modify, and convert spreadsheets in .NET 6, .NET Framework, .NET Core/Standard, Mono, and Xamarin. Applications using this spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. The powerful calculation engine and breadth of features means you’ll never have to compromise on design or requirements.
At A Glance:
- Create, load, edit, and save Excel spreadsheets
- Save to .XLSX, PDF, HTML, CSV, and JSON
- Based on the Excel Object Model with zero Excel dependencies
- Deploy locally, inhouse or to Cloud including Azure and AWS
- 450+ Excel Functions and custom functions supported to perform complex calculations
- Use the Templates to create custom Excel reports
Based on the extensive Excel Object Model, the interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VS Tools for Office-style API, you can create custom styles using the same elements as VS Tools for Office.
Using GcExcel, you can create full reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard reports, add charts, slicers, sparklines, conditional formats, import and export Excel templates, convert spreadsheets to PDF and so much more.
GcExcel comes with a full-featured JavaScript Data viewer control (GcDataViewer).
If you'd like to remove the watermark and other trial limitations, please email us.sales@grapecity.com to request your 30-day evaluation key.
Complete Client-Server Spreadsheet Solution
You can optionally integrate GcExcel with the SpreadJS JavaScript spreadsheet as a client side editor/viewer solution when working with Excel files for a complete client-server solution. View the complete supported features list here or download a trial from NPM or the SpreadJS page.
Resources
- Download 30-day Evaluation
- Product Page
- Online Demo
- DsDataViewer Demo
- Getting Started
- License Information
- Licensing FAQ
- How to get Trial Keys
- GcExcel Blogs
- Online Documentation
- Offline Documentation (PDF)
Other GrapeCity Document API Solutions
- Documents for Excel, Java
- Documents for PDF
- Documents for PDF Viewer
- Documents for Word
- Documents for Imaging
Important information: A Shift from 'GrapeCity Documents' to 'Document Solutions'for US Edition {: #note}
重要信息:对于 'GrapeCity Documents' 中国版本,组件名已经更改为 'GcDocs'。
GrapeCity Documents has undergone a marketing rebranding and as a result, the v7.2 Maintenance release in November 2024 will mark the final release under the old GrapeCity Documents product branding.
Starting with version 8.0.0 and onwards releases, the packages will only be released using the new package names and this current GrapeCity package will be phased out.
It is highly recommended to update to these new packages as soon as you can. Transitioning to the new packages has been simplified through the Documents Migration tool, conveniently included in the product trial download zip files available for the respective products:
- US Edition: Download Document Solutions
- 中国版本: 下载GcDocs for Excel, .NET
Please note that despite the adoption of new package names, the APIs, namespaces, and type names remain unchanged. You will not need to modify your code. Only the package names and DLL names have been changed, just requiring updates to the new package references.
Existing subscriptions will continue to receive the new package updates. If you have any questions or need any assistance with this update, please contact our support teams. Please find the nuget package links for new packages below::
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. 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 | 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 4.6.1
- GrapeCity.Documents.Barcode (>= 7.2.0)
- GrapeCity.Documents.Imaging.Windows (>= 7.2.0)
- GrapeCity.Documents.Pdf (>= 7.2.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.Drawing.Common (>= 6.0.0)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 6.0.1)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Json (>= 6.0.0)
-
.NETStandard 2.0
- GrapeCity.Documents.Barcode (>= 7.2.0)
- GrapeCity.Documents.Pdf (>= 7.2.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 6.0.1)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Json (>= 6.0.0)
-
net6.0
- GrapeCity.Documents.Barcode (>= 7.2.0)
- GrapeCity.Documents.Pdf (>= 7.2.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 6.0.1)
-
net6.0-windows7.0
- GrapeCity.Documents.Barcode (>= 7.2.0)
- GrapeCity.Documents.Imaging.Windows (>= 7.2.0)
- GrapeCity.Documents.Pdf (>= 7.2.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.Drawing.Common (>= 6.0.0)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 6.0.1)
NuGet packages (6)
Showing the top 5 NuGet packages that depend on GrapeCity.Documents.Excel:
Package | Downloads |
---|---|
C1.AspNetCore.Api.Excel
ComponentOne Controls for ASP.NET Core MVC Edition |
|
C1.AspNetCore.Api.Excel.ja
ComponentOne Controls for ASP.NET Core MVC Edition |
|
Verify.GrapeCity
Extends Verify (https://github.com/VerifyTests/Verify) to allow verification via GrapeCity Documents API. |
|
C1.AspNetCore.Api.Excel.cn
ComponentOne Controls for ASP.NET Core MVC Edition |
|
GrapeCity.ActiveReports.Core.DataProviders.Excel
ActiveReports Excel data provider facility |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
7.2.1 | 66 | 8/30/2024 |
7.2.0 | 369 | 8/20/2024 |
7.1.5 | 1,146 | 7/19/2024 |
7.1.4 | 647 | 6/27/2024 |
7.1.3 | 1,228 | 6/7/2024 |
7.1.2 | 538 | 5/16/2024 |
7.1.1 | 2,402 | 4/29/2024 |
7.1.0 | 1,743 | 4/16/2024 |
7.0.5 | 2,480 | 3/21/2024 |
7.0.4 | 2,651 | 2/29/2024 |
7.0.3 | 1,807 | 2/7/2024 |
7.0.2 | 944 | 1/19/2024 |
7.0.1 | 4,075 | 1/2/2024 |
7.0.0 | 2,094 | 12/11/2023 |
6.2.5 | 7,609 | 11/21/2023 |
6.2.4 | 2,101 | 11/3/2023 |
6.2.3 | 3,354 | 10/13/2023 |
6.2.2 | 5,465 | 9/15/2023 |
6.2.1 | 1,312 | 8/25/2023 |
6.2.0 | 4,210 | 8/7/2023 |
6.1.4 | 1,900 | 7/21/2023 |
6.1.3 | 5,203 | 7/7/2023 |
6.1.2 | 5,113 | 6/16/2023 |
6.1.1 | 5,010 | 5/26/2023 |
6.1.0 | 8,522 | 5/8/2023 |
6.0.6 | 7,104 | 4/7/2023 |
6.0.5 | 6,005 | 3/17/2023 |
6.0.4 | 18,247 | 2/24/2023 |
6.0.3 | 5,391 | 2/3/2023 |
6.0.2 | 4,234 | 1/6/2023 |
6.0.1 | 2,822 | 12/23/2022 |
6.0.0 | 2,818 | 12/12/2022 |
5.2.5 | 62,466 | 11/24/2022 |
5.2.4 | 1,970 | 11/4/2022 |
5.2.3 | 13,820 | 10/13/2022 |
5.2.2 | 11,841 | 9/16/2022 |
5.2.1 | 1,482 | 8/26/2022 |
5.2.0 | 2,172 | 8/15/2022 |
5.1.5 | 3,404 | 7/26/2022 |
5.1.4 | 4,266 | 7/7/2022 |
5.1.3 | 5,149 | 6/16/2022 |
5.1.2 | 2,879 | 5/27/2022 |
5.1.1 | 1,860 | 5/7/2022 |
5.1.0 | 5,092 | 4/20/2022 |
5.0.5 | 5,716 | 3/23/2022 |
5.0.4 | 5,237 | 3/4/2022 |
5.0.3 | 6,186 | 2/11/2022 |
5.0.2 | 1,803 | 1/14/2022 |
5.0.1 | 3,622 | 12/26/2021 |
5.0.0 | 11,867 | 12/13/2021 |
4.2.6 | 119,055 | 11/23/2021 |
4.2.5 | 3,055 | 11/5/2021 |
4.2.4 | 1,195 | 10/15/2021 |
4.2.3 | 1,052 | 9/27/2021 |
4.2.2 | 957 | 9/24/2021 |
4.2.1 | 2,029 | 9/3/2021 |
4.2.0 | 3,674 | 8/16/2021 |
4.1.4 | 1,166 | 7/29/2021 |
4.1.3 | 17,609 | 7/9/2021 |
4.1.2 | 3,990 | 6/15/2021 |
4.1.1 | 1,977 | 5/20/2021 |
4.1.0 | 4,875 | 4/28/2021 |
4.0.5 | 1,236 | 4/9/2021 |
4.0.4 | 2,803 | 3/8/2021 |
4.0.3 | 1,653 | 1/29/2021 |
4.0.2 | 12,607 | 1/7/2021 |
4.0.1 | 1,894 | 12/9/2020 |
4.0.0 | 4,123 | 11/20/2020 |
3.2.4 | 6,981 | 10/30/2020 |
3.2.3 | 4,996 | 9/29/2020 |
3.2.2 | 2,290 | 8/28/2020 |
3.2.1 | 1,721 | 8/7/2020 |
3.2.0 | 1,342 | 7/21/2020 |
3.1.5 | 1,777 | 6/19/2020 |
3.1.4 | 1,207 | 6/4/2020 |
3.1.3 | 2,531 | 5/18/2020 |
3.1.2 | 6,603 | 4/28/2020 |
3.1.1 | 1,319 | 4/10/2020 |
3.1.0 | 2,697 | 3/5/2020 |
3.0.4 | 2,306 | 1/17/2020 |
3.0.3 | 1,340 | 1/7/2020 |
3.0.2 | 3,838 | 12/11/2019 |
3.0.1 | 4,653 | 11/22/2019 |
3.0.0 | 4,682 | 10/24/2019 |
2.2.7 | 10,390 | 11/11/2019 |
2.2.6 | 2,535 | 9/20/2019 |
2.2.5 | 1,248 | 9/5/2019 |
2.2.4 | 1,570 | 8/22/2019 |
2.2.3 | 1,380 | 8/7/2019 |
2.2.2 | 3,982 | 7/15/2019 |
2.2.1 | 2,237 | 6/20/2019 |
2.2.0 | 1,591 | 6/10/2019 |
2.1.5 | 1,541 | 4/28/2019 |
2.1.4 | 1,293 | 4/12/2019 |
2.1.3 | 1,443 | 3/28/2019 |
2.1.2 | 1,295 | 3/14/2019 |
2.1.1 | 3,834 | 3/6/2019 |
2.1.0 | 1,722 | 1/25/2019 |
2.0.5 | 1,443 | 12/19/2018 |
2.0.4 | 4,347 | 12/6/2018 |
2.0.3 | 1,577 | 11/22/2018 |
2.0.2 | 1,438 | 11/14/2018 |
2.0.1 | 1,578 | 10/25/2018 |
2.0.0 | 1,639 | 9/29/2018 |
1.5.0.4 | 2,576 | 8/20/2018 |
1.5.0.3 | 2,004 | 6/8/2018 |
1.5.0.1 | 1,856 | 5/1/2018 |
# Changes from version 7.1.5:
## Added
- Support Asynchronous IMAGE function.(DOCXLS-6740)
- Support Label and Value Filter in PivotTable.(DOCXLS-7568)
- Support Pixel-Based rendering in PDF and Image Export.(DOCXLS-8690)
- Support UID attribute when loading and saving Excel file.(DOCXLS-8756)
- Support filtering data from single/multiple data sources in Template Language.(DOCXLS-8835)
- Support display of filter button in column header for SJS and SSJSON export.(DOCXLS-9036)
- Support LINESPARKLINE/COLUMNSPARKLINE/WINLOSSSPARKLINE functions.(DOCXLS-9324)
- Support Goal Seek functionality.(DOCXLS-9389)
- Support customising Border Style in PDF Export.(DOCXLS-9624)
- Support for FromSJSJson API to load single SJS JSON file.(DOCXLS-9928)
## Fixed
- The image size is not same as the PDF file exported by SpreadJS.(DOCXLS-897)
- The exported XLSM file is corrupted when opening in MSExcel.(DOCXLS-5849)
- When a specific xlsx file is loaded and saved, the saved file is corrupted.(DOCXLS-6040)
- Wrapped text cannot be fully displayed in the exported PDF file.(DOCXLS-6762,DOCXLS-10267)
- The pagination results in the exported PDF file are inconsistent with SpreadJS.(DOCXLS-7128,DOCXLS-7897,DOCXLS-8743,DOCXLS-8827,DOCXLS-10278,DOCXLS-10334)
- The rotated circular shapes are distorted in the exported image files.(DOCXLS-8526)
- The line breaks in the exported PDF file are inconsistent with the PDF file exported by SpreadJS.(DOCXLS-8664,DOCXLS-8898,DOCXLS-9359,DOCXLS-10161,DOCXLS-10385)
- The size of the QR code in the exported PDF file is not same as SpreadJS.(DOCXLS-8801)
- The borders of some cells are lost in the exported Excel file after loading the SJS file.(DOCXLS-9244)
- The cell format is changed in the exported SJS file and Excel file after loading the original SJS file.(DOCXLS-9272,DOCXLS-9575,DOCXLS-9866,DOCXLS-10025,DOCXLS-10156)
- The cell format is changed in the exported SJS file after inserting specific rows.(DOCXLS-9341)
- The page margins in the exported PDF file are inconsistent with SpreadJS.(DOCXLS-9500)
- The seal is stretched in the exported PDF file.(DOCXLS-9588)
- The cell background image is inconsistent with SpreadJS in the exported PDF file.(DOCXLS-9611)
- The filtering status of PivotTable in the exported Excel file is changed.(DOCXLS-9613)
- The table border in the exported PDF file is thicker than the PDF exported by SpreadJS.(DOCXLS-9620)
- Some whitespace characters are missing in the exported PDF file.(DOCXLS-9722,DOCXLS-10365,DOCXLS-10888)
- The table style is changed in the exported SJS file.(DOCXLS-9876)
- The border style is changed in the exported SJS file.(DOCXLS-9993)
- Exception is thrown on saving Excel file containing Charts to PDF file with Norway culture.(DOCXLS-10167)
- Exception is thrown on refreshing the PivotTable.(DOCXLS-10239)
- The font size is changed in the exported SJS file after loading the original SJS file.(DOCXLS-10447)
- The conditional format is incorrect in the exported SJS file.(DOCXLS-10453)
- Incorrect value returned from array formula when calculation engine is off.(DOCXLS-10709)
- The table style in the exported PDF file is incorrect.(DOCXLS-10774)
- Some cell values are not exported in the Excel file when license is not set.(DOCXLS-10805)
- The result of the LOG function is incorrect.(DOCXLS-10822)
- Exception is thrown on setting the orientation of PivotField to column field and row field.(DOCXLS-10828)
- The result of the SEARCH function is incorrect.(DOCXLS-10859)