GrapeCity.Documents.Excel 3.1.1

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.1.1
dotnet add package GrapeCity.Documents.Excel --version 3.1.1
<PackageReference Include="GrapeCity.Documents.Excel" Version="3.1.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.Documents.Excel --version 3.1.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: GrapeCity.Documents.Excel, 3.1.1"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Release Notes

# Changes from version 3.1.0:

## Fixed
- Certain cell border lines do not render correctly when exporting to PDF.(DOCXLS-713)
- The order of legend for chart in exported pdf is incorrect if legend across lines.(DOCXLS-1579)
- Issue occurs when inserting new row to an existing table.(DOCXLS-1936)
- Cell Formatter change after saveJson. (DOCXLS-2013)
- In Excel, the horizontal break line will be ignored when set the exporting height fit to 1 page(s).(DOCXLS-2097)
- IRange.Copy() cannot copy pictures sometimes.(DOCXLS-2153)
- Save Excel containing Chart shows different output.(DOCXLS-2155)
- The color of DataSeries of Chart is incorrect in exported pdf.(DOCXLS-2160)
- Name is lost after cutting table.(DOCXLS-2169)
- Stack overflow occus after cutting table.(DOCXLS-2170)
- Data validation is lost after sheet json.(DOCXLS-2175)
- Sometimes, the print area does not work.(DOCXLS-2176)
- Error occurs when fromJSON. (DOCXLS-2182)
- BackgroundPicture don't update after reset width and height if use Tile in BackgroundImageLayout. (DOCXLS-2186)
- After export PDF, a minus number is not red when use format like "0.00_;[Red]-0.00". (DOCXLS-2188)
- Picture don't update after reset width and height afert export PDF.(DOCXLS-2208)
- Formula does not change after inserting row or binding data.(DOCXLS-2220)
- The row becomes hidden after inserting row and save to json. (DOCXLS-2222)
- Error occurs during fromJSON. (DOCXLS-2227)
- ArrayIndexOutOfBounds exception occurs when cutting table.(DOCXLS-2235)
- Picture don't update after duplicating operation. (DOCXLS-2241)
- Copying a sheet containing a chart to another workbook corrupts the book.(DOCXLS-2247)
- Calculation result is incorrect if different reference methods are used together in SUBTOTAL function.(DOCXLS-2257)
- After export to PDF, some text can not display completely.(DOCXLS-2258)
- Error occurs after opening Excel file saved by GcExcel.(DOCXLS-2261)
- Error occurs during from json.(DOCXLS-2262)
- Formulas is incorrectly marked as array formulas.(DOCXLS-2266)
- Data is lost after importting an Excel. (DOCXLS-2268)
- After enable PageSetup.BestFitRows, there maybe exception when save to PDF.(DOCXLS-2291)
- After enable PageSetup.BestFitRows, the exported PDF is strange.(DOCXLS-2292)
- Exception is thrown during saving to PDF when you set gradient color fill in background picture.(DOCXLS-2293)
- Background picture's gradient fill is not correct in exported PDF file.(DOCXLS-2296)
- The cell value is incorrect in the exported PDF.(DOCXLS-2303)
- Hidden row becomes visible after save JSON.(DOCXLS-2308)
- Chart markers are not drawn correctly in exported PDF.(DOCXLS-2309)
- Incorrect calculation for CountIF formula.(DOCXLS-2310)
- There is an exception When exportting PDF.(DOCXLS-2314)
- ComboBox CellType throw errors when fromJSON.(DOCXLS-2315)
- BackgroundPicture's gradient fill is not right after export PDF.(DOCXLS-2316)
- Cell vertical alignment is changed after from JSON.(DOCXLS-2331)
- Error occurs during from JSON. (DOCXLS-2337)
- The large currency number is wrong in the exported PDF.(DOCXLS-2338)
- Error occurs when importing JSON with chart.(DOCXLS-2342)

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 187 1/29/2021
4.0.2 684 1/7/2021
4.0.1 334 12/9/2020
4.0.0 899 11/20/2020
3.2.4 628 10/30/2020
3.2.3 1,185 9/29/2020
3.2.2 710 8/28/2020
3.2.1 623 8/7/2020
3.2.0 301 7/21/2020
3.1.5 734 6/19/2020
3.1.4 243 6/4/2020
3.1.3 648 5/18/2020
3.1.2 432 4/28/2020
3.1.1 347 4/10/2020
3.1.0 1,615 3/5/2020
3.0.4 819 1/17/2020
3.0.3 433 1/7/2020
3.0.2 1,197 12/11/2019
3.0.1 3,302 11/22/2019
3.0.0 1,838 10/24/2019
2.2.7 3,892 11/11/2019
2.2.6 1,549 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,319 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 490 3/28/2019
2.1.2 329 3/14/2019
2.1.1 372 3/6/2019
2.1.0 757 1/25/2019
2.0.5 480 12/19/2018
2.0.4 3,411 12/6/2018
2.0.3 636 11/22/2018
2.0.2 500 11/14/2018
2.0.1 630 10/25/2018
2.0.0 592 9/29/2018
1.5.0.4 1,314 8/20/2018
1.5.0.3 885 6/8/2018
1.5.0.1 656 5/1/2018
Show less