GrapeCity.Documents.Excel 5.2.5

.NET Standard 2.0 .NET Framework 4.6.1
dotnet add package GrapeCity.Documents.Excel --version 5.2.5
NuGet\Install-Package GrapeCity.Documents.Excel -Version 5.2.5
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="GrapeCity.Documents.Excel" Version="5.2.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.Documents.Excel --version 5.2.5
#r "nuget: GrapeCity.Documents.Excel, 5.2.5"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install GrapeCity.Documents.Excel as a Cake Addin
#addin nuget:?package=GrapeCity.Documents.Excel&version=5.2.5

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

GrapeCity Documents for Excel

Programmatically create Excel .xlsx spreadsheets with ease in your server or desktop applications. GrapeCity Documents for Excel (GcExcel) is a cross-platform high-speed, small-footprint spreadsheet API library that requires no dependencies on Excel. With full .NET 6 support, you can programmatically generate, load, modify, and convert spreadsheets in .NET 6, .NET Framework, .NET Core/Standard, Mono, and Xamarin. Applications using this spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. The powerful calculation engine and breadth of features means you’ll never have to compromise on design or requirements.

At A Glance:

  • Create, load, edit, and save Excel spreadsheets
  • Save to .XLSX, PDF, HTML, CSV, and JSON
  • Based on the Excel Object Model with zero Excel dependencies
  • Deploy locally, inhouse or to Cloud including Azure and AWS
  • 450+ Excel Functions and custom functions supported to perform complex calculations
  • Use the Templates to create custom Excel reports

Based on the extensive Excel Object Model, the interface-based API allows you to import, calculate, query, generate, and export any spreadsheet scenario. With the VS Tools for Office-style API, you can create custom styles using the same elements as VS Tools for Office.

Using GcExcel, you can create full reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard reports, add charts, slicers, sparklines, conditional formats, import and export Excel templates, convert spreadsheets to PDF and so much more.

Complete Client-Server Spreadsheet Solution You can optionally integrate GcExcel with the SpreadJS JavaScript spreadsheet as a client side editor/viewer solution when working with Excel files for a complete client-server solution. View the complete supported features list here or download a trial from NPM or the SpreadJS page.

If you'd like to remove the watermark and other trial limitations, please email us.sales@grapecity.com to request your 30-day evaluation key.

Resources

Other GrapeCity Document API Solutions

Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (12)

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

ComponentOne Document library for WinForms は、ドキュメントとレポートの作成をサポートします。 【本パッケージは日本語版製品です】

C1.WPF.Grid.Excel

FlexGrid Import and Export is a library which enables importing and exporting FlexGrid's data from and to an excel file.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
5.2.5 129 11/24/2022
5.2.4 473 11/4/2022
5.2.3 932 10/13/2022
5.2.2 2,484 9/16/2022
5.2.1 491 8/26/2022
5.2.0 1,016 8/15/2022
5.1.5 1,135 7/26/2022
5.1.4 2,322 7/7/2022
5.1.3 2,163 6/16/2022
5.1.2 1,570 5/27/2022
5.1.1 957 5/7/2022
5.1.0 2,938 4/20/2022
5.0.5 2,582 3/23/2022
5.0.4 2,790 3/4/2022
5.0.3 2,879 2/11/2022
5.0.2 1,026 1/14/2022
5.0.1 2,445 12/26/2021
5.0.0 6,943 12/13/2021
4.2.6 71,833 11/23/2021
4.2.5 1,360 11/5/2021
4.2.4 544 10/15/2021
4.2.3 374 9/27/2021
4.2.2 311 9/24/2021
4.2.1 765 9/3/2021
4.2.0 3,022 8/16/2021
4.1.4 534 7/29/2021
4.1.3 10,539 7/9/2021
4.1.2 2,592 6/15/2021
4.1.1 1,057 5/20/2021
4.1.0 2,992 4/28/2021
4.0.5 578 4/9/2021
4.0.4 1,280 3/8/2021
4.0.3 775 1/29/2021
4.0.2 7,692 1/7/2021
4.0.1 1,200 12/9/2020
4.0.0 2,413 11/20/2020
3.2.4 2,088 10/30/2020
3.2.3 3,379 9/29/2020
3.2.2 1,278 8/28/2020
3.2.1 947 8/7/2020
3.2.0 631 7/21/2020
3.1.5 1,093 6/19/2020
3.1.4 529 6/4/2020
3.1.3 1,351 5/18/2020
3.1.2 5,835 4/28/2020
3.1.1 634 4/10/2020
3.1.0 1,990 3/5/2020
3.0.4 1,412 1/17/2020
3.0.3 696 1/7/2020
3.0.2 2,057 12/11/2019
3.0.1 3,838 11/22/2019
3.0.0 3,046 10/24/2019
2.2.7 7,940 11/11/2019
2.2.6 1,828 9/20/2019
2.2.5 550 9/5/2019
2.2.4 888 8/22/2019
2.2.3 710 8/7/2019
2.2.2 2,922 7/15/2019
2.2.1 1,546 6/20/2019
2.2.0 772 6/10/2019
2.1.5 862 4/28/2019
2.1.4 605 4/12/2019
2.1.3 758 3/28/2019
2.1.2 599 3/14/2019
2.1.1 646 3/6/2019
2.1.0 1,021 1/25/2019
2.0.5 741 12/19/2018
2.0.4 3,660 12/6/2018
2.0.3 891 11/22/2018
2.0.2 748 11/14/2018
2.0.1 888 10/25/2018
2.0.0 893 9/29/2018
1.5.0.4 1,854 8/20/2018
1.5.0.3 1,264 6/8/2018
1.5.0.1 1,089 5/1/2018

# Changes from version 5.2.4:

## Fixed
        
- The column width of exported PDF is inconsistent with SpreadJS.(DOCXLS-6857)
- IndexOutOfRangeException is thrown on calling Calculate method twice for a workbook.(DOCXLS-6873)
- Performance issue in opening Excel file and saving to JSON when workbook contains lots of comments.(DOCXLS-6886)
- The exported report is incorrect when sheet name is bind to the datafield with DataSet as datasource.(DOCXLS-6889)
- The layout is incorrect on call the IPivotTable.refresh() method.(DOCXLS-6890)
- Field name is missed in the exported report when using the Range and Group feature of template at the same time.(DOCXLS-6892)
- The border is lost in the exported SSJSON file.(DOCXLS-6896)
- Loading the specific SSJSON file, some node would be discarded.(DOCXLS-6902)
- Template is not processed correctly.(DOCXLS-6909)
- Table formula is not updated when using template.(DOCXLS-6916)
- The result of sorting is incorrect when there are CJK characters.(DOCXLS-6975)
- Performance issue with Add function in dynamic array.(DOCXLS-6979)
- Exception is thrown on loading Excel file which contains irregualr content.(DOCXLS-6981)
- Exception is thrown on loading particular SSJSON file with Pivot Table.(DOCXLS-6982)
- InvalidOperationException is thrown on getting cell value twice from a workbook.(DOCXLS-6988)
- The number format is missed when data source contains date value.(DOCXLS-6996)
- The row height is incorrect after calling autofit method.(DOCXLS-7005)
- The cell value is incorrect when workbook contains cross workbook reference.(DOCXLS-7008)
- Exception is thrown on loading particular SSJSON file contains conditional format with entire column reference.(DOCXLS-7024)
- The SUMIF function result is incorrect.(DOCXLS-7032)