GrapeCity.Documents.Excel 1.5.0.3

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 1.5.0.3

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

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

paket add GrapeCity.Documents.Excel --version 1.5.0.3

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

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

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

Release Notes

Bug Fixing
- PDF is now saved correctly when the width of the column exceeds the width of paper.

Enhancements
- The StandardWidthInPixel property has been introduced in order to allow users to get or set the standard width(in pixel) of all the columns in the worksheet.
- The StandardHeightInPixel property has been introduced in order to allow users to get or set the standard height(in pixel) of all the rows in the worksheet.
- While setting borders for a range, users also have the option to reset the range's adjacent border using the ResetAdjacentRangeBorder property.
- Now, you can use CellInfo class with some helper functions.

Performance
- Now, you can get or set the single cell values in a spreadsheet considerably faster than before.
- The performance of setting an array of double/int/float values to a range has been significantly improved. For instance, Range.Value = new double[,]{ {1d, 2d}, {3d, 4d}}.
- You can get or set the style for a single cell in a worksheet quickly and efficiently.

Dependencies

• .NETStandard 2.0

  • GrapeCity.Documents.Common (>= 1.0.0.107)
  • GrapeCity.Documents.Pdf (>= 1.0.0.107)
  • System.Reflection.Emit.ILGeneration (>= 4.3.0)
  • System.Reflection.Emit.Lightweight (>= 4.3.0)

Used By

Version History