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

Install-Package GrapeCity.Documents.Excel -Version 3.0.0

dotnet add package GrapeCity.Documents.Excel --version 3.0.0

<PackageReference Include="GrapeCity.Documents.Excel" Version="3.0.0" />

paket add GrapeCity.Documents.Excel --version 3.0.0

#r "nuget: GrapeCity.Documents.Excel, 3.0.0"

// Install GrapeCity.Documents.Excel as a Cake Addin
#addin nuget:?package=GrapeCity.Documents.Excel&version=3.0.0

// Install GrapeCity.Documents.Excel as a Cake Tool
#tool nuget:?package=GrapeCity.Documents.Excel&version=3.0.0

Release Notes

New Features
- Templates support to generate Excel reports.
- Support conversion of Excel spreadsheets having sharts to PDF.
- Support conversion of Excel spreadsheets having slicers to PDF.
- Support new Excel 2016 chart types.
- Support security options when saving to PDF.
- Support document properties when saving to PDF.
- Protect workbook.
- Support chart sheet.
- Support shape with hyperlink.
- Group/Ungroup shapes.
- Calculate outline subtotal.
- Get precedents and dependents of formula cell.
- Add pivot table's grand totals and report layout options similar to Excel.
- Support shape adjustment.
- Support sheet background image to PDF.
- Export Excel files with multiple images to PDF with reduced file size.
- Support license workbook instance.
- Rename pivot fields and Data Fields.
- Support cell tags of GrapeCity SpreadJS.
- Support cell types of GrapeCity SpreadJS.
- Support best fit rows/columns feature of GrapeCity SpreadJS.

Bugs Fixed
- NullReferenceException is thrown on Workbook.ToJson() and Workbook.Save() method.(DOCXLS-1377)
- Unable to set Icon  for IconCriteria.(DOCXLS-1531s)
- "_xlfn" prefix added before IFNA formula while converting to JSON.(DOCXLS-1537s)
- The precision of calculated result is incorrect.(DOCXLS-1547)

Dependencies

• .NETFramework 4.6.1

  • GrapeCity.Documents.DataVisualization.Chart (>= 0.3.242)
  • GrapeCity.Documents.Pdf (>= 3.0.0.414)

• .NETStandard 2.0

  • GrapeCity.Documents.DataVisualization.Chart (>= 0.3.242)
  • GrapeCity.Documents.Pdf (>= 3.0.0.414)

Used By

Version History