GrapeCity.Documents.Excel 4.0.0

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

Install-Package GrapeCity.Documents.Excel -Version 4.0.0
dotnet add package GrapeCity.Documents.Excel --version 4.0.0
<PackageReference Include="GrapeCity.Documents.Excel" Version="4.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.Documents.Excel --version 4.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

# Changes from version 3.2.4:

## Added
- Support for new PDF Form custom input types in Excel Templates with advanced input and validation settings.
- Support for adding, modifying and deleting Pivot Charts in Excel documents.
- Support for iterative calculations in Excel documents.
- Add Barcodes on PDF, HTML or Image Export
- Support cross-workbook formula.
- Support setting default value for template cell.
- Get range address to get cell's address.
- Add page printing events to track progress of Excel to PDF conversion.
- Select multiple worksheets.
- Get special cells in a range.
- Disable auto grouping for date/times in PivotTable.
- Add more features for GrapeCity SpreadJS integration: cell buttons, radio and checkbox list cell type, etc.

## Fixed
- PivotTable MergeLabel's merged area is incorrect.(DOCXLS-3181)
- PivotTable.DataBodyRange throws exception.(DOCXLS-3283)
- Can't open the xlsx when the pivot source contains null values.(DOCXLS-3285)
- Failed to export an Excel with pivot table.(DOCXLS-3297)
- Program does not end and CPU utilisation is 100% when exporting to PDF.(DOCXLS-2744)
- Broken Excel file is generated when copying a sheet.(DOCXLS-3252)
- ArrayIndexOutOfBoundsException when generating JSON.(DOCXLS-3165)
- When margins are set to the same value, the rendering position is not the same in PDF.(DOCXLS-3211)
- Labels does not merge in exported xlsx file.(DOCXLS-3262)
- SUM is calculated incorrectly when using GcExcel template functionality.(DOCXLS-3267)
- PDF form is not displayed when 'printed' and 'hidden' settings are false in form field.(DOCXLS-3275)
- Rows are not repeating while using GcExcel Template.(DOCXLS-3278)
- Null exception is thrown during loading ssjson.(DOCXLS-3290)
- Null exception is thrown when calling Workbook.Calculate.(DOCXLS-3299)
- The text in exported image is wrong.(DOCXLS-3314)
- The pivot table label does not merge in exported xlsx file.(DOCXLS-3262)

NuGet packages (3)

Showing the top 3 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.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
4.0.0 198 11/20/2020
3.2.4 338 10/30/2020
3.2.3 772 9/29/2020
3.2.2 458 8/28/2020
3.2.1 586 8/7/2020
3.2.0 254 7/21/2020
3.1.5 641 6/19/2020
3.1.4 213 6/4/2020
3.1.3 461 5/18/2020
3.1.2 366 4/28/2020
3.1.1 315 4/10/2020
3.1.0 1,542 3/5/2020
3.0.4 781 1/17/2020
3.0.3 398 1/7/2020
3.0.2 1,027 12/11/2019
3.0.1 3,067 11/22/2019
3.0.0 1,653 10/24/2019
2.2.7 3,392 11/11/2019
2.2.6 1,516 9/20/2019
2.2.5 266 9/5/2019
2.2.4 584 8/22/2019
2.2.3 405 8/7/2019
2.2.2 1,206 7/15/2019
2.2.1 1,216 6/20/2019
2.2.0 399 6/10/2019
2.1.5 541 4/28/2019
2.1.4 320 4/12/2019
2.1.3 459 3/28/2019
2.1.2 303 3/14/2019
2.1.1 339 3/6/2019
2.1.0 673 1/25/2019
2.0.5 391 12/19/2018
2.0.4 3,303 12/6/2018
2.0.3 528 11/22/2018
2.0.2 394 11/14/2018
2.0.1 523 10/25/2018
2.0.0 503 9/29/2018
1.5.0.4 1,119 8/20/2018
1.5.0.3 793 6/8/2018
1.5.0.1 566 5/1/2018