GrapeCity.Documents.Excel 3.1.2

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.1.2

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

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

paket add GrapeCity.Documents.Excel --version 3.1.2

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

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

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

Release Notes

# Changes from version 3.1.1:

## Fixed
- Exception is thrown when cutting tables.(DOCXLS-2288)
- The line style in exported pdf is not same as it is in Excel.(DOCXLS-2297)
- The default date format is not changed by culture.(DOCXLS-2318)
- Exception occurs when copying a sheet from another workbook and saving the workbook.(DOCXLS-2334)
- There are unexpected lines on top of cell in the exported pdf.(DOCXLS-2339)
- The saved Excel file is corrupted.(DOCXLS-2345)
- Some values in the exported Excel file are incorrect.(DOCXLS-2352)
- It takes a long time to open an Excel with a lot of inline strings.(DOCXLS-2353)
- The plot area's boundary is incorrect in the exported pdf.(DOCXLS-2356)
- ToJson would take a very long time.(DOCXLS-2364)
- The content is incorrect in the exported pdf.(DOCXLS-2365)
- Font files will be kept opening event after saving pdf.(DOCXLS-2372)
- RepeatSetting doesn't work if there is only one row on the last page.(DOCXLS-2376])
- Picture is not clear after exporting to PDF.(DOCXLS-2384)
- Column width changes in the exported Excel.(DOCXLS-2385)
- The calculated result is incorrect.(DOCXLS-2387)
- Exception is thrown during from json.(DOCXLS-2390)

## Changed
- General formatter is used when invalid number format was found during getting cell text, previous behavior is throwing exception.

Dependencies

• .NETFramework 4.6.1

  • GrapeCity.Documents.DataVisualization.Chart (>= 13.0.13)
  • GrapeCity.Documents.Pdf (>= 3.1.0.512)

• .NETStandard 2.0

  • GrapeCity.Documents.DataVisualization.Chart (>= 13.0.13)
  • GrapeCity.Documents.Pdf (>= 3.1.0.512)

Used By

Version History