GcDocs.Excel
7.2.2
dotnet add package GcDocs.Excel --version 7.2.2
NuGet\Install-Package GcDocs.Excel -Version 7.2.2
<PackageReference Include="GcDocs.Excel" Version="7.2.2" />
paket add GcDocs.Excel --version 7.2.2
#r "nuget: GcDocs.Excel, 7.2.2"
// Install GcDocs.Excel as a Cake Addin #addin nuget:?package=GcDocs.Excel&version=7.2.2 // Install GcDocs.Excel as a Cake Tool #tool nuget:?package=GcDocs.Excel&version=7.2.2
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.Formats.Asn1 (>= 6.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- 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.Formats.Asn1 (>= 6.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- 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.Formats.Asn1 (>= 6.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- 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.Formats.Asn1 (>= 6.0.1)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- 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.2 | 178 | 9/18/2024 |
7.2.1 | 153 | 8/30/2024 |
7.2.0 | 313 | 8/20/2024 |
7.1.5 | 142 | 7/19/2024 |
7.1.4 | 124 | 6/27/2024 |
7.1.3 | 117 | 6/7/2024 |
7.1.2 | 140 | 5/16/2024 |
7.1.1 | 153 | 4/29/2024 |
7.1.0 | 196 | 4/16/2024 |
7.0.5 | 141 | 3/21/2024 |
7.0.4 | 142 | 2/29/2024 |
7.0.3 | 163 | 2/7/2024 |
7.0.2 | 144 | 1/19/2024 |
7.0.1 | 607 | 1/2/2024 |
7.0.0 | 226 | 12/11/2023 |
# Changes from version 7.2.1:
## Fixed
- There are many unexpected diagonal lines in the exported PDF file.(DOCXLS-10988)
- Exception is thrown on exporting HTML file if some shape width is zero.(DOCXLS-11082)
- The exported Excel file is corrupted when the source data of the PivotChart contains CalcError.(DOCXLS-11102)
- The result of AVERAGEIF function is incorrect.(DOCXLS-11117)
- Exception is thrown on opening an SJS file that contains invalid quality factor.(DOCXLS-11118)
- The text that exceeds the boundaries of the shapes has not been cropped in the exported PDF file.(DOCXLS-11119)
- After setting the value to a cell range, the row count of the sheet becomes 1048576.(DOCXLS-11122)
- The sheet order is incorrect in the exported SJS file.(DOCXLS-11123)
- Performance issue on calling ProcessTemplate method.(DOCXLS-11124)
- Exception is thrown on opening an XLSX file that contains invalid DocPros data.(DOCXLS-11125)
- Exception is thrown on setting the orientation of PivotField as ColumnField.(DOCXLS-11129)
- Performance issue on deleting rows.(DOCXLS-11130)
- The result of EXACT function is different from Excel.(DOCXLS-11133)
- After copying the sheet, the cell displayed as #BUSY contains IMAGE function in the exported PDF file.(DOCXLS-11136)
- The result is 0 when the cell refers to the IMAGE function in the exported PDF file.(DOCXLS-11137)