GrapeCity.Documents.Excel 2.1.1

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

Install-Package GrapeCity.Documents.Excel -Version 2.1.1

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

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

paket add GrapeCity.Documents.Excel --version 2.1.1

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

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

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

Release Notes

Enhancements
- Added IWorksheet.FixedPageBreaks to control whether to adjust page breaks after inserting/deleting rows or columns.
- Improved the effect of wrapped text to pdf.

Bug Fixed
- Page breaks are not adjusted after inserting/deleting rows or columns.(DOCXLS-728)
- NullReferenceException is thrown after calling IRange.ClearContents().(DOCXLS-731)
- NullReferenceException occurs on editing and saving XML generated by ClosedXML.(DOCXLS-726)
- Refreshing a PivotTable through code and saving it, corrupts the generated Excel file.(DOCXLS-739)
- ArgumentOutOfRangeException thrown on refreshing PivotTable present in some *.xlsx file.(DOCXLS-740)
- On deleting the active sheet and saving the Excel file, an error dialog is observed on opening the saved Excel file.(DOCXLS-747)
- StackOverflowException is thrown on invoking SetSourceData for Chart.(DOCXLS-724)
- Color.Empty leaves black color on a cell.(DOCXLS-722)
- Error is thrown while using FromJson method.(DOCXLS-734)
- Using MAXIFS function results in #NAME? error in cell.(DOCXLS-749)

Dependencies

• .NETFramework 4.6.1

  • GrapeCity.Documents.Pdf (>= 2.1.0.262)

• .NETStandard 2.0

  • GrapeCity.Documents.Pdf (>= 2.1.0.262)

Used By

Version History