GcDocs.Excel
7.2.5
dotnet add package GcDocs.Excel --version 7.2.5
NuGet\Install-Package GcDocs.Excel -Version 7.2.5
<PackageReference Include="GcDocs.Excel" Version="7.2.5" />
paket add GcDocs.Excel --version 7.2.5
#r "nuget: GcDocs.Excel, 7.2.5"
// Install GcDocs.Excel as a Cake Addin #addin nuget:?package=GcDocs.Excel&version=7.2.5 // Install GcDocs.Excel as a Cake Tool #tool nuget:?package=GcDocs.Excel&version=7.2.5
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.3)
- GcDocs.Imaging.Windows (>= 7.2.3)
- GcDocs.Pdf (>= 7.2.3)
- 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.10)
-
.NETStandard 2.0
- GcDocs.Barcode (>= 7.2.3)
- GcDocs.Pdf (>= 7.2.3)
- 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.10)
-
net6.0
- GcDocs.Barcode (>= 7.2.3)
- GcDocs.Pdf (>= 7.2.3)
- 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.3)
- GcDocs.Imaging.Windows (>= 7.2.3)
- GcDocs.Pdf (>= 7.2.3)
- 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 (3)
Showing the top 3 NuGet packages that depend on GcDocs.Excel:
Package | Downloads |
---|---|
C1.Win.Document.Cn
The ComponentOne Document library for WinForms provides support for creating documents and reports. |
|
C1.Win.C1Document.Cn
The ComponentOne Document library for WinForms 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.5 | 153 | 11/21/2024 |
7.2.4 | 122 | 10/31/2024 |
7.2.3 | 149 | 10/10/2024 |
7.2.2 | 373 | 9/18/2024 |
7.2.1 | 182 | 8/30/2024 |
7.2.0 | 401 | 8/20/2024 |
7.1.5 | 162 | 7/19/2024 |
7.1.4 | 144 | 6/27/2024 |
7.1.3 | 129 | 6/7/2024 |
7.1.2 | 153 | 5/16/2024 |
7.1.1 | 168 | 4/29/2024 |
7.1.0 | 212 | 4/16/2024 |
7.0.5 | 150 | 3/21/2024 |
7.0.4 | 151 | 2/29/2024 |
7.0.3 | 178 | 2/7/2024 |
7.0.2 | 156 | 1/19/2024 |
7.0.1 | 635 | 1/2/2024 |
7.0.0 | 237 | 12/11/2023 |
# Changes from version 7.2.4:
## Fixed
- When copying array formulas and exporting them to Excel, the reference ranges change.(DOCXLS-11412)
- The form fields are incorrect in the exported PDF file after processing template.(DOCXLS-11416)
- Some conditional formats are lost in the exported Excel file.(DOCXLS-11419)
- Exception is thrown on opening a specific Excel file with a password.(DOCXLS-11445)
- The XMATCH function does not return correct value if lookup array contains empty cells.(DOCXLS-11448)
- Exception is thrown on loading SJS file contains null author in comment.(DOCXLS-11469)
- The autofit method does not work after setting wrap text to the cell.(DOCXLS-11478)
- The slicers are lost in the exported Excel file after processing template.(DOCXLS-11479)
- Spill error shows in array functions in the exported Excel file when calculation engine is off.(DOCXLS-11488)
- The conditional formatting is incorrect in the exported Excel file after processing template.(DOCXLS-11491)
- Exception is thrown on processing template when filter condition contains negative number.(DOCXLS-11504)
- The hidden rows/columns are lost after calling IRange.Copy() method.(DOCXLS-11506)
- Exception is thrown on processing template when template file contains specific chart.(DOCXLS-11531)
- Exception is thrown on processing template if the filtered field is empty.(DOCXLS-11567)