GrapeCity.Documents.Excel 2.2.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

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

Release Notes

New Features
- Export Excel files with shapes to pdf.
- Cut/copy ranges between different workbooks.
- Copy/move worksheet between different workbooks.
- Control whether to adjust page breaks after inserting/deleting rows/columns.
- Customize the row/column/cell delemiter when loading or saving csv file.
- Set the tail repeated rows and right repeated columns when saving to pdf.
- Support for paste options during copy and paste ranges.
- Support IRange.Find() and IRange.Replace() methods.
- Show or hide different kinds of pivot table styles.
- Support for exporting pivot table styles to pdf.
- Support setting the number format for each pivot field.
- Japanese ruby can now be preserved after Excel I/O.
- Get and customize each page settings before saving to pdf file.
- Render any sheet range inside a pdf file.
- Keep rows/columns togother when saving to pdf.
- Save multiple workbooks to one pdf file.
- Export specific pages from spreadsheet to pdf
- Save multiple spreadsheet pages into one pdf page.
- Support IRange.AutoFit method to fit rows/columns.
- Support IRange.FormulaArrayR1C1 property to get or set array formula in R1C1 format.
- Support more import flags during open an Excel file.
- OLEObject will be preserved after Excel I/O.
- Support Shrink to fit, wrapped text while saving to pdf.

- Reference GcPdf v2.2.0.310

Bug Fixed
- GcExcel ignores 'ignore_empty' parameter in TEXTJOIN formula.(DOCXLS-970)
- Large JSON file generated when using ToJson on a particular Workbook.(DOCXLS-968)
- UsedRange.Value sets improper values to the range when Formula is set to Empty.(DOCXLS-956)

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
2.2.3 95 8/7/2019
2.2.2 184 7/15/2019
2.2.1 526 6/20/2019
2.2.0 208 6/10/2019
2.1.5 396 4/28/2019
2.1.4 188 4/12/2019
2.1.3 336 3/28/2019
2.1.2 168 3/14/2019
2.1.1 182 3/6/2019
2.1.0 538 1/25/2019
2.0.5 265 12/19/2018
2.0.4 2,566 12/6/2018
2.0.3 389 11/22/2018
2.0.2 255 11/14/2018
2.0.1 391 10/25/2018
2.0.0 353 9/29/2018 561 8/20/2018 615 6/8/2018 367 5/1/2018