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

There is a newer version of this package available.
See the version list below for details.
Install-Package GrapeCity.Documents.Excel -Version 3.1.0
dotnet add package GrapeCity.Documents.Excel --version 3.1.0
<PackageReference Include="GrapeCity.Documents.Excel" Version="3.1.0" />
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.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: GrapeCity.Documents.Excel, 3.1.0"
#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=3.1.0

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

Release Notes

Added
- Support for charts/images/conditional formatting in Templates.
- Support exporting formulas in Templates.
- Support global settings in Templates.
- Support converting Excel objects(chart/shape) to image formats.
- Support password protected workbook and worksheet.
- Support adding Error Bars in Chart.
- Support text angle of chart title/axis tick label/data label.
- Support alignment of Shape's TextFrame.
- Add image to specific range.
- Support Gradient Fill Type enum in Shapes.
- Support creating chart/shape/pictures with a custom name.
- Enhanced Background image support for printing to PDF.
- Get pagination info for printing to PDF.
- Support Transparent Cell Background color in PDF.
- Support worksheet JSON I/O.
- Support Outline column to display hierarchical data in saved PDF.
- Support data binding of Range, Table and Worksheet.
- Return errors from JSON Import in GcExcel.

Fixed
- Filtered data cannot be re-displayed after JSON(made by SJS) I/O in GcExcel.(DOCXLS-1646)
- Exception occurs on loading specific ssjson.(DOCXLS-2158)
- Exception may occur on exporting certain Excel sheets with charts to PDF (DOCXLS-2094)
- Hiding fixed columns and rows causes incorrect display in Excel file.(DOCXLS-2020)
- Pagination is inconsistent with SpreadJS when the form is exported to PDF.(DOCXLS-2159)
- JSON file size is bigger when converted using GcExcel vs Online designer tool.(DOCXLS-1905)
- The Value property value of the ComboBox cell is lost after JSON I/O.(DOCXLS-2029)
- NullPointerException may occur on loading certain Excel file and saving it. (DOCXLS-2041)
- Conditional formatting is lost if the rule references another sheet.(DOCXLS-2093)

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.1 243 5/20/2021
4.1.0 248 4/28/2021
4.0.5 250 4/9/2021
4.0.4 894 3/8/2021
4.0.3 361 1/29/2021
4.0.2 1,087 1/7/2021
4.0.1 486 12/9/2020
4.0.0 1,282 11/20/2020
3.2.4 776 10/30/2020
3.2.3 1,474 9/29/2020
3.2.2 794 8/28/2020
3.2.1 724 8/7/2020
3.2.0 373 7/21/2020
3.1.5 804 6/19/2020
3.1.4 302 6/4/2020
3.1.3 749 5/18/2020
3.1.2 639 4/28/2020
3.1.1 402 4/10/2020
3.1.0 1,666 3/5/2020
3.0.4 894 1/17/2020
3.0.3 489 1/7/2020
3.0.2 1,317 12/11/2019
3.0.1 3,584 11/22/2019
3.0.0 2,153 10/24/2019
2.2.7 4,302 11/11/2019
2.2.6 1,612 9/20/2019
2.2.5 348 9/5/2019
2.2.4 669 8/22/2019
2.2.3 495 8/7/2019
2.2.2 1,543 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 810 1/25/2019
2.0.5 536 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 666 10/25/2018
2.0.0 651 9/29/2018
1.5.0.4 1,497 8/20/2018
1.5.0.3 942 6/8/2018
1.5.0.1 721 5/1/2018
Show less