GrapeCity.Documents.Excel 4.0.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 4.0.4
dotnet add package GrapeCity.Documents.Excel --version 4.0.4
<PackageReference Include="GrapeCity.Documents.Excel" Version="4.0.4" />
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.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: GrapeCity.Documents.Excel, 4.0.4"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install GrapeCity.Documents.Excel as a Cake Addin
#addin nuget:?package=GrapeCity.Documents.Excel&version=4.0.4

// Install GrapeCity.Documents.Excel as a Cake Tool
#tool nuget:?package=GrapeCity.Documents.Excel&version=4.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

# Changes from version 4.0.3:

## Fixed
- Generating SSJSON takes longer time.(DOCXLS-3598)
- Insert Range shows Invalid Operation Exception in certain cases.(DOCXLS-3638)
- ArrayIndexOutOfBoundsException while opening the file.(DOCXLS-3712)
- File takes 17min to open unless shapes disabled.(DOCXLS-3725)
- Taking longer time to get value from a cell.(DOCXLS-3736)
- Getting cell value take more time after copying it to another sheet.(DOCXLS-3738)
- Setting formula fails with exception.(DOCXLS-3742)
- Copying range fails with exception.(DOCXLS-3743)
- Getting value from source after copying takes more than 5 minutes.(DOCXLS-3744)
- Excel with pivot table corrupted after saving using GcExcel API.(DOCXLS-3747)
- NullPointerException when saving copy.(DOCXLS-3750)
- Excel corrupted after hiding columns using GcExcel API.(DOCXLS-3751)
- IndexOutOfBoundsException when saving workbook.(DOCXLS-3752)
- Cannot read formula in copied file.(DOCXLS-3765)
- Broken file produced during copy.(DOCXLS-3766)
- Removing formula in copied workbook fails with exception.(DOCXLS-3767)
- ProtectionOptions setting lost after saving to json using GcExcel.(DOCXLS-3772)
- Cached value lost in sourceSheet after copying range, Different behavior when copying range and sheet.(DOCXLS-3773)
- Calculation hangs in workbook copied using ssjson.(DOCXLS-3805)
- Structured references in table cells not calculating after range copy/paste between worksheets.(DOCXLS-3806)
- ArgumentOutOfRangeException occurs when calculating excel file with External Links.(DOCXLS-3471)
- Unexpected border in PivotTable in the exported Pdf.(DOCXLS-3770)
- Exception occurs after calling IPivotTable.Update().(DOCXLS-3797)
- Problem exporting PDF with text orientation.(DOCXLS-3455)
- IllegalArgumentException on opening attached Excel file.(DOCXLS-3472)
- Copy result is not correct if copy entire single row to multi rows and target rows contains entire merge areas.(DOCXLS-3538)
- Java API column setHidden() method is not working properly.(DOCXLS-3563)
- After the excel file toJson, data validation is lost.(DOCXLS-3649)
- After GCExcel imports and exports ssjson,the chart type has changed.(DOCXLS-3650)
- Invalid values after calculation with Release 4.0.2.(DOCXLS-3669)
- IRange.Find won't work while the search string end with "~".(DOCXLS-3708)
- Sheet password does not work after saving by GCExcel.(DOCXLS-3715)
- Exception of type 'GrapeCity.Documents.Excel.InvalidFormulaException' was thrown when Cutting a range in sheet to another workbook.(DOCXLS-3720)
- Getting the background color of entire column is wrong.(DOCXLS-3740)
- When pareto chart and funnel chart are exported to a PDF, NullReferenceException occurs.(DOCXLS-3781)
- Cells Text Orientation is not deserialised to Json.(DOCXLS-3816)
- Incorrect JSON gets exported for grouped Columns.(DOCXLS-3821)

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
ComponentOne Document library for WinForms は、ドキュメントとレポートの作成をサポートします。 【本パッケージは日本語版製品です】
C1.Win.FlexGrid.ImportExport.Ja
ComponentOne FlexGrid for WinForms のインポートおよびエクスポート機能を提供します。 【本パッケージは日本語版製品です】

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
4.1.2 26 6/15/2021
4.1.1 262 5/20/2021
4.1.0 260 4/28/2021
4.0.5 254 4/9/2021
4.0.4 896 3/8/2021
4.0.3 362 1/29/2021
4.0.2 1,095 1/7/2021
4.0.1 490 12/9/2020
4.0.0 1,286 11/20/2020
3.2.4 777 10/30/2020
3.2.3 1,476 9/29/2020
3.2.2 794 8/28/2020
3.2.1 728 8/7/2020
3.2.0 379 7/21/2020
3.1.5 805 6/19/2020
3.1.4 302 6/4/2020
3.1.3 756 5/18/2020
3.1.2 672 4/28/2020
3.1.1 402 4/10/2020
3.1.0 1,668 3/5/2020
3.0.4 894 1/17/2020
3.0.3 489 1/7/2020
3.0.2 1,318 12/11/2019
3.0.1 3,589 11/22/2019
3.0.0 2,155 10/24/2019
2.2.7 4,310 11/11/2019
2.2.6 1,613 9/20/2019
2.2.5 349 9/5/2019
2.2.4 670 8/22/2019
2.2.3 495 8/7/2019
2.2.2 1,544 7/15/2019
2.2.1 1,295 6/20/2019
2.2.0 485 6/10/2019
2.1.5 622 4/28/2019
2.1.4 403 4/12/2019
2.1.3 547 3/28/2019
2.1.2 386 3/14/2019
2.1.1 428 3/6/2019
2.1.0 811 1/25/2019
2.0.5 537 12/19/2018
2.0.4 3,442 12/6/2018
2.0.3 675 11/22/2018
2.0.2 536 11/14/2018
2.0.1 667 10/25/2018
2.0.0 651 9/29/2018
1.5.0.4 1,499 8/20/2018
1.5.0.3 942 6/8/2018
1.5.0.1 721 5/1/2018