GcDocs.Excel
7.2.0
See the version list below for details.
dotnet add package GcDocs.Excel --version 7.2.0
NuGet\Install-Package GcDocs.Excel -Version 7.2.0
<PackageReference Include="GcDocs.Excel" Version="7.2.0" />
paket add GcDocs.Excel --version 7.2.0
#r "nuget: GcDocs.Excel, 7.2.0"
// Install GcDocs.Excel as a Cake Addin #addin nuget:?package=GcDocs.Excel&version=7.2.0 // Install GcDocs.Excel as a Cake Tool #tool nuget:?package=GcDocs.Excel&version=7.2.0
GrapeCity Documents for Excel, .NET
GrapeCity Documents for Excel, .NET (GcExcel .NET) 是一款跨平台、高性能、小巧的 Excel API 库,无需依赖 Excel。基于.NET 6 的全面支持,您可以以编程方式生成、加载、修改和转换.NET 6、.NET Framework、.NET Core/Standard、Mono 和 Xamarin 应用程序中的电子表格。使用此电子表格 API 的应用程序可以部署到云、Windows、Mac 或 Linux,并且具有强大的计算引擎和广泛的功能。
功能
- 创建,打开,编辑和保存电子表格
- 保存为.XLSX、PDF、HTML、CSV 和 JSON
- 基于 Excel 对象模型,无需依赖 Excel
- 本地部署、内部部署或云部署(包括 Azure 和 AWS)
- 支持 450+ Excel 函数和自定义函数,用于执行复杂的计算
- 使用模板创建自定义 Excel 报告
基于全面的 Excel 对象模型,接口化 API 可以帮助您满足导入、计算、查询、生成和导出等各种电子表格场景。
使用 GcExcel,您可以创建完整的报表,对表格或者数据透视表排序及过滤、创建仪表板报告、添加图表、切片器、迷你图、条件格式、导入和导出 Excel 模板,以及将电子表格转换为 PDF 等等。
如果您想删除试用版本中的水印,请致电 400-657-6008 或发送邮件到 info.xa@grapecity.com,咨询30天的试用key。
完整的前后端电子表格解决方案
您可以选择将 GcExcel 与 SpreadJS JavaScript 电子表格集成,将 SpreadJS 作为前端的编辑器/浏览器,以实现完整的前后端解决方案。您可以从这里了解 SpreadJS 的功能,或者通过 NPM 或者 SpreadJS 页面下载试用。
相关资源
其他 GrapeCity Document API 解决方案
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
- GcDocs.Barcode (>= 7.2.0)
- GcDocs.Imaging.Windows (>= 7.2.0)
- GcDocs.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
- GcDocs.Barcode (>= 7.2.0)
- GcDocs.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
- GcDocs.Barcode (>= 7.2.0)
- GcDocs.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
- GcDocs.Barcode (>= 7.2.0)
- GcDocs.Imaging.Windows (>= 7.2.0)
- GcDocs.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 (2)
Showing the top 2 NuGet packages that depend on GcDocs.Excel:
Package | Downloads |
---|---|
C1.Document.Cn
The ComponentOne Document library provides support for creating documents and reports. |
|
GCCN.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.4 | 98 | 10/31/2024 |
7.2.3 | 123 | 10/10/2024 |
7.2.2 | 286 | 9/18/2024 |
7.2.1 | 165 | 8/30/2024 |
7.2.0 | 323 | 8/20/2024 |
7.1.5 | 146 | 7/19/2024 |
7.1.4 | 125 | 6/27/2024 |
7.1.3 | 118 | 6/7/2024 |
7.1.2 | 141 | 5/16/2024 |
7.1.1 | 154 | 4/29/2024 |
7.1.0 | 204 | 4/16/2024 |
7.0.5 | 142 | 3/21/2024 |
7.0.4 | 143 | 2/29/2024 |
7.0.3 | 170 | 2/7/2024 |
7.0.2 | 148 | 1/19/2024 |
7.0.1 | 627 | 1/2/2024 |
7.0.0 | 228 | 12/11/2023 |
# 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)