GcDocs.Excel
7.0.1
See the version list below for details.
dotnet add package GcDocs.Excel --version 7.0.1
NuGet\Install-Package GcDocs.Excel -Version 7.0.1
<PackageReference Include="GcDocs.Excel" Version="7.0.1" />
paket add GcDocs.Excel --version 7.0.1
#r "nuget: GcDocs.Excel, 7.0.1"
// Install GcDocs.Excel as a Cake Addin #addin nuget:?package=GcDocs.Excel&version=7.0.1 // Install GcDocs.Excel as a Cake Tool #tool nuget:?package=GcDocs.Excel&version=7.0.1
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 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 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.0.0)
- GcDocs.Imaging.Windows (>= 7.0.0)
- GcDocs.Pdf (>= 7.0.0)
- Microsoft.CSharp (>= 4.5.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.Drawing.Common (>= 5.0.2)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 4.7.1)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Json (>= 5.0.2)
-
.NETStandard 2.0
- GcDocs.Barcode (>= 7.0.0)
- GcDocs.Imaging.Windows (>= 7.0.0)
- GcDocs.Pdf (>= 7.0.0)
- Microsoft.CSharp (>= 4.5.0)
- Microsoft.Extensions.Logging.Abstractions (>= 3.1.7)
- Newtonsoft.Json (>= 13.0.1)
- System.Drawing.Common (>= 5.0.2)
- System.IO.Packaging (>= 4.5.0)
- System.Security.Cryptography.Xml (>= 4.7.1)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Json (>= 5.0.2)
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 | 140 | 11/21/2024 |
| 7.2.4 | 119 | 10/31/2024 |
| 7.2.3 | 142 | 10/10/2024 |
| 7.2.2 | 344 | 9/18/2024 |
| 7.2.1 | 180 | 8/30/2024 |
| 7.2.0 | 389 | 8/20/2024 |
| 7.1.5 | 160 | 7/19/2024 |
| 7.1.4 | 143 | 6/27/2024 |
| 7.1.3 | 129 | 6/7/2024 |
| 7.1.2 | 152 | 5/16/2024 |
| 7.1.1 | 167 | 4/29/2024 |
| 7.1.0 | 211 | 4/16/2024 |
| 7.0.5 | 149 | 3/21/2024 |
| 7.0.4 | 150 | 2/29/2024 |
| 7.0.3 | 177 | 2/7/2024 |
| 7.0.2 | 155 | 1/19/2024 |
| 7.0.1 | 634 | 1/2/2024 |
| 7.0.0 | 236 | 12/11/2023 |
# Changes from version 6.2.5:
## Fixed
- It takes more than 5 minutes to export specific SSJSON file to pdf.(DOCXLS-8989)
- Unexpected diagonal border is exported in the XLSX file.(DOCXLS-9173)
- The result of AGGREGATE formula is incorrect.(DOCXLS-9287)
- The font style of shape is incorrect in the exported PDF file.(DOCXLS-9300)
- The icon of conditional format in the exported HTML file is different from Excel and SpreadJS.(DOCXLS-9302)
- Some back color of cells change to black in the exported PDF file.(DOCXLS-9313)
- Exception is thrown on loading a specific XLSX file.(DOCXLS-9335)
- Exception is thrown on loading a specific XLSX file.(DOCXLS-9339)
- Exception is thrown on loading a specific SSJSON file if the file contains invalid chart data.(DOCXLS-9340)
- Performance issue while calculating workbook.(DOCXLS-9360)
- The conditional formatting styles are lost after loading an SSJSON file then exporting to SJS file.(DOCXLS-9364)
- The call of method PrintManager.paginate() takes too much time.(DOCXLS-9387)
- When the special xlsx with hyperlinks is loaded and saved, the saved xlsx is corrupted.(DOCXLS-9395)
- Some cells that were not locked became locked after loading an SJS file then exporting to another SJS file.(DOCXLS-9401)
- The returned value of fromJson does not contain formula error.(DOCXLS-9402)
- Exception is thrown on calling Workbook.ToJson() method.(DOCXLS-9406)
- Exception is thrown on opening an SSJSON file contains invalid formulas.(DOCXLS-9416)
- The result of VDB function is different from Excel.(DOCXLS-9427)
- The formula is not updated after calling IWorksheet.FromJson().(DOCXLS-9433)
- The text is incorrect in the exported PDF file.(DOCXLS-9448)
- The center header of page setup can not be set using IPage.CenterHeader.Text method.(DOCXLS-9479)
- Exception is thrown on copying worksheet to another workbook.(DOCXLS-9510)