GrapeCity.Documents.Excel 2.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 http://demos.componentone.com/gcdocs/gcexcel

There is a newer version of this package available.
See the version list below for details.
Install-Package GrapeCity.Documents.Excel -Version 2.1.0
dotnet add package GrapeCity.Documents.Excel --version 2.1.0
<PackageReference Include="GrapeCity.Documents.Excel" Version="2.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 2.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: GrapeCity.Documents.Excel, 2.1.0"
For F# scripts that support #r syntax, copy this into the source code to reference the package.

Release Notes

Bug Fixed
- The Workbook.Calculate() method now evaluates the cell values correctly.
- While saving an Excel file to open XML format, the logical value of the cell is now calculated without any errors.
New Features
- Users can now import and export spreadsheets that contain macros. While these will not be executed, the macros will now be preserved when saving.
- Users can now load and save GrapeCity SpreadJS JSON files with shapes.
- Users can now set rich text format in the cells by applying multiple styles to the textual information entered in the cell.
- While working with custom named styles, users can now modify an existing style and add it to the Styles collection.
- Users can now export Excel files with vertical text to PDF.
- Users can now insert any background image to the worksheet including their organization logo, custom watermark or a wallpaper of their choice without any issues.
- Enhanced pivot table to support auto date field group in Excel 2016.
- Added some overload open/save methods to avoid passing file format.

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