GrapeCity.Documents.Excel 3.2.4

GrapeCity Documents for Excel is a high-speed, small-footprint spreadsheet API that requires no dependencies on Excel. With full .NET Standard 2.0 support, you can generate, load, modify, and convert spreadsheets in .NET Framework, .NET Core, Mono, and Xamarin. Apps using this spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. Its powerful calculation engine and breadth of features means you’ll never have to compromise design or requirements.

We model our interface-based API on Excel's document object model. This means that you can import, calculate, query, generate, and export any spreadsheet scenario.

Using GcExcel, you can create full reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard reports, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF.

The online Documents for Excel sample browser is available at https://www.grapecity.com/documents-api-excel/demos

There is a newer version of this package available.
See the version list below for details.
Install-Package GrapeCity.Documents.Excel -Version 3.2.4
dotnet add package GrapeCity.Documents.Excel --version 3.2.4
<PackageReference Include="GrapeCity.Documents.Excel" Version="3.2.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.Documents.Excel --version 3.2.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: GrapeCity.Documents.Excel, 3.2.4"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Release Notes

# Changes from version 3.2.3:

## Fixed
- DataValidation does not work for added rows for Table.(DOCXLS-3158)
- PivotTable's row field is missing after PivotTable.AddDataField().(DOCXLS-3174)
- Exception occurs when exporting Pivot Table to PDF.(DOCXLS-3176)
- PivotTable.RowRange throws exception if there is no row fields.(DOCXLS-3179)
- Table Resize with one row table lost conditional format and data validation.(DOCXLS-3194)
- The printed area does not consider hidden rows and columns.(DOCXLS-3206)
- The calculated result of Lookup formula is different with Excel.(DOCXLS-3177)
- The IRange.Columns.AutoFit() result is wrong when wrapping text.(DOCXLS-3178)
- PivotTable column fields' vertical alignment is wrong after setting MergeLabels to true.(DOCXLS-3180)
- Import ssjson and export to PDF, the program is blocked.(DOCXLS-3216)
- InvalidFormulaException is thrown when importing ssjson.(DOCXLS-3242)
- IRange.AutoFit() does not consider ConditionalFormatting's icon size.(DOCXLS-3117)
- It takes over 40 seconds to export to json.(DOCXLS-3138)
- The calculated result is wrong when array formula and custom function work together.(DOCXLS-3141)
- Richtext is lost in the exported image.(DOCXLS-3142)
- Null reference exception is thrown while exporting to json.(DOCXLS-3166)
- Null reference exception is thrown while opening an Excel with chart.(DOCXLS-3167)
- CloneNotSupportedException when copying sheet with Top/Bottom % conditional formatting rule.(DOCXLS-3169)
- Column width is not autofit correctly when Autofit() method is applied to a cell with full-width characters entered.(DOCXLS-3172)
- Grouped rows displayed in UI even after calling showLevels(1,0) after exporting to ssjson.(DOCXLS-3173)
- PivotTable's border style is wrong in the exported PDF.(DOCXLS-3175)
- The calculated style of conditional formats is wrong in the exported PDF.(DOCXLS-3234)
- NullPointerException in ArrayList occurs when copying a single cell after opening Excel File.(DOCXLS-3235)
- The Pivot Table label's resource should be "值" instead of "Values".(DOCXLS-3236)
- When workbook is exported to PDF, value axis' maximum scale in radar chart are changed.(DOCXLS-3239)
- The quote prefix is lost in the exported ssjson.(DOCXLS-3240)
- PdfSaveOptions is not applied to the output PDF when IWorksheet.Save() is used.(DOCXLS-3246)
- Spans are lost after fromJSON.(DOCXLS-3250)

NuGet packages (5)

Showing the top 5 NuGet packages that depend on GrapeCity.Documents.Excel:

Package Downloads
C1.AspNetCore.Api.Excel
ComponentOne Controls for ASP.NET Core MVC Edition
C1.Win.Document
The ComponentOne Document library for WinForms provides support for creating documents and reports.
C1.Win.FlexGrid.ImportExport
Provides import and export functionality for ComponentOne FlexGrid for WinForms.
C1.Win.Document.Ja
The ComponentOne Document library for WinForms provides support for creating documents and reports.
C1.Win.FlexGrid.ImportExport.Ja
Provides import and export functionality for ComponentOne FlexGrid for WinForms.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
4.0.3 136 1/29/2021
4.0.2 601 1/7/2021
4.0.1 299 12/9/2020
4.0.0 867 11/20/2020
3.2.4 591 10/30/2020
3.2.3 1,149 9/29/2020
3.2.2 683 8/28/2020
3.2.1 621 8/7/2020
3.2.0 300 7/21/2020
3.1.5 734 6/19/2020
3.1.4 243 6/4/2020
3.1.3 610 5/18/2020
3.1.2 410 4/28/2020
3.1.1 346 4/10/2020
3.1.0 1,591 3/5/2020
3.0.4 818 1/17/2020
3.0.3 433 1/7/2020
3.0.2 1,165 12/11/2019
3.0.1 3,273 11/22/2019
3.0.0 1,791 10/24/2019
2.2.7 3,817 11/11/2019
2.2.6 1,548 9/20/2019
2.2.5 292 9/5/2019
2.2.4 612 8/22/2019
2.2.3 432 8/7/2019
2.2.2 1,277 7/15/2019
2.2.1 1,243 6/20/2019
2.2.0 428 6/10/2019
2.1.5 566 4/28/2019
2.1.4 347 4/12/2019
2.1.3 486 3/28/2019
2.1.2 329 3/14/2019
2.1.1 370 3/6/2019
2.1.0 757 1/25/2019
2.0.5 480 12/19/2018
2.0.4 3,380 12/6/2018
2.0.3 605 11/22/2018
2.0.2 469 11/14/2018
2.0.1 599 10/25/2018
2.0.0 592 9/29/2018
1.5.0.4 1,291 8/20/2018
1.5.0.3 884 6/8/2018
1.5.0.1 656 5/1/2018