GcDocs.Excel 7.1.0

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.6.1 This package targets .NET Framework 4.6.1. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package GcDocs.Excel --version 7.1.0                

                    
                

            
NuGet\Install-Package GcDocs.Excel -Version 7.1.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="GcDocs.Excel" Version="7.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add GcDocs.Excel --version 7.1.0                

                    
                

            
#r "nuget: GcDocs.Excel, 7.1.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install GcDocs.Excel as a Cake Addin
#addin nuget:?package=GcDocs.Excel&version=7.1.0

// Install GcDocs.Excel as a Cake Tool
#tool nuget:?package=GcDocs.Excel&version=7.1.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 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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 96 10/31/2024
7.2.3 123 10/10/2024
7.2.2 283 9/18/2024
7.2.1 165 8/30/2024
7.2.0 321 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.0.5:

## Added
- Enhance Template Language with better performance.(DOCXLS-5722)
- Ignore errors in range.(DOCXLS-8310)
- Support for interrupting execution of ProcessTemplate method.(DOCXLS-8396)
- Template Language supports OverwriteWithFormat under Classic Mode.(DOCXLS-8515)
- Support lossless .sjs/ssjson I/O of GanttSheet.(DOCXLS-8629)
- Support CalculationMode options.(DOCXLS-8750)
- Search cells with tags.(DOCXLS-8759)
- Support multi column sorting in Template Language.(DOCXLS-8818)
- Support custom sort order in Template Language.(DOCXLS-8819)
- Get and set cell background images.(DOCXLS-8829)
- Support table reference in cross workbook formulas.(DOCXLS-8859)
- Export Barcodes as Pictures in Excel files.(DOCXLS-9278)
- Support lossless .sjs/ssjson I/O of ReportSheet.(DOCXLS-9625)

## Fixed
- Exception is thrown on calling ProcessTemplate method when data source is not found.(DOCXLS-5052)
- The grouped result is incorrect after calling ProcessTemplate method when using JSON data source.(DOCXLS-6476)
- The result of SUMIFS formula is incorrect after processing template file.(DOCXLS-6596)
- Exception is thrown on calling ProcessTemplate method when data field is numeric.(DOCXLS-8098)
- The result in the report workbook is incorrect after processing the template file.(DOCXLS-8489)
- The result of SUM formula is incorrect after processing the template file.(DOCXLS-8514)
- The merge area is incorrect after processing the template file.(DOCXLS-8656)
- The result of DIV formula is incorrect after processing the template file.(DOCXLS-8669)
- The cell background color is not expanded as expected in the exported report workbook.(DOCXLS-8709)
- The result of MIN and MAX formula is incorrect after processing the template file.(DOCXLS-8786)
- The calculated result is incorrect in the exported report workbook after processing the template file.(DOCXLS-8834)
- The formula is changed in the exported report workbook after processing the template file.(DOCXLS-9002)
- Exception is thrown on calling ProcessTemplate method.(DOCXLS-9023)
- Performance issue on processing template when setting G=R.(DOCXLS-9041)
- The apply range of conditional format is changed in the exported workbook.(DOCXLS-9046)
- The chart in the exported PDF file is incorrect.(DOCXLS-9579)
- The ISort.Apply() method didn't work as intended.(DOCXLS-9853)
- Performance issue on processing template containing merged cell.(DOCXLS-9961)
- The border is lost in the exported XLSX file.(DOCXLS-10015)
- Image is lost in the exported XLSX file when PaginationMode is true.(DOCXLS-10020)
- The row/column header caption in Pivot Table is lost in the exported XLSX file.(DOCXLS-10044)
- Exception is thrown on loading particular SSJSON file.(DOCXLS-10047)
- Exception is thrown on loading particular SJS file.(DOCXLS-10084)
- The result of the DATEVALUE formula is incorrect.(DOCXLS-10085)
- Performance issue on processing template when there're too many sheets.(DOCXLS-10088)
- The table formula is not expanded correctly when calling ProcessTemplate method.(DOCXLS-10090)
- Exception is thrown on loading worksheet from JSON containing non-existent external references.(DOCXLS-10092)