GrapeCity.Documents.Excel 2.2.0

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.6.1 This package targets .NET Framework 4.6.1. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package GrapeCity.Documents.Excel --version 2.2.0                

                    
                

            
NuGet\Install-Package GrapeCity.Documents.Excel -Version 2.2.0
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="2.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add GrapeCity.Documents.Excel --version 2.2.0                

                    
                

            
#r "nuget: GrapeCity.Documents.Excel, 2.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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=2.2.0

// Install GrapeCity.Documents.Excel as a Cake Tool
#tool nuget:?package=GrapeCity.Documents.Excel&version=2.2.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 http://demos.componentone.com/gcdocs/gcexcel

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

NuGet packages (6)

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.AspNetCore.Api.Excel.ja

ComponentOne Controls for ASP.NET Core MVC Edition
Verify.GrapeCity

Extends Verify (https://github.com/VerifyTests/Verify) to allow verification via GrapeCity Documents API.
C1.AspNetCore.Api.Excel.cn

ComponentOne Controls for ASP.NET Core MVC Edition
GrapeCity.ActiveReports.Core.DataProviders.Excel

ActiveReports Excel data provider facility

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
7.2.3 3,152 10/10/2024
7.2.2 768 9/18/2024
7.2.1 3,795 8/30/2024
7.2.0 4,905 8/20/2024
7.1.5 6,106 7/19/2024
7.1.4 730 6/27/2024
7.1.3 1,355 6/7/2024
7.1.2 828 5/16/2024
7.1.1 9,122 4/29/2024
7.1.0 1,973 4/16/2024
7.0.5 2,891 3/21/2024
7.0.4 3,190 2/29/2024
7.0.3 2,817 2/7/2024
7.0.2 1,099 1/19/2024
7.0.1 4,791 1/2/2024
7.0.0 2,251 12/11/2023
6.2.5 13,103 11/21/2023
6.2.4 2,670 11/3/2023
6.2.3 3,709 10/13/2023
6.2.2 5,604 9/15/2023
6.2.1 1,365 8/25/2023
6.2.0 4,449 8/7/2023
6.1.4 1,952 7/21/2023
6.1.3 6,050 7/7/2023
6.1.2 5,323 6/16/2023
6.1.1 5,455 5/26/2023
6.1.0 9,465 5/8/2023
6.0.6 7,417 4/7/2023
6.0.5 6,841 3/17/2023
6.0.4 23,112 2/24/2023
6.0.3 5,804 2/3/2023
6.0.2 4,311 1/6/2023
6.0.1 2,960 12/23/2022
6.0.0 2,849 12/12/2022
5.2.5 97,872 11/24/2022
5.2.4 1,997 11/4/2022
5.2.3 13,876 10/13/2022
5.2.2 13,120 9/16/2022
5.2.1 1,515 8/26/2022
5.2.0 2,426 8/15/2022
5.1.5 3,812 7/26/2022
5.1.4 4,386 7/7/2022
5.1.3 5,318 6/16/2022
5.1.2 2,904 5/27/2022
5.1.1 1,901 5/7/2022
5.1.0 5,313 4/20/2022
5.0.5 6,123 3/23/2022
5.0.4 5,470 3/4/2022
5.0.3 6,426 2/11/2022
5.0.2 1,834 1/14/2022
5.0.1 3,658 12/26/2021
5.0.0 12,240 12/13/2021
4.2.6 119,089 11/23/2021
4.2.5 3,102 11/5/2021
4.2.4 1,226 10/15/2021
4.2.3 1,084 9/27/2021
4.2.2 987 9/24/2021
4.2.1 2,416 9/3/2021
4.2.0 3,712 8/16/2021
4.1.4 1,192 7/29/2021
4.1.3 18,609 7/9/2021
4.1.2 4,170 6/15/2021
4.1.1 2,006 5/20/2021
4.1.0 5,053 4/28/2021
4.0.5 1,272 4/9/2021
4.0.4 3,095 3/8/2021
4.0.3 1,703 1/29/2021
4.0.2 13,020 1/7/2021
4.0.1 1,929 12/9/2020
4.0.0 4,244 11/20/2020
3.2.4 8,021 10/30/2020
3.2.3 5,348 9/29/2020
3.2.2 2,344 8/28/2020
3.2.1 1,780 8/7/2020
3.2.0 1,372 7/21/2020
3.1.5 1,815 6/19/2020
3.1.4 1,240 6/4/2020
3.1.3 2,574 5/18/2020
3.1.2 6,636 4/28/2020
3.1.1 1,375 4/10/2020
3.1.0 2,728 3/5/2020
3.0.4 2,342 1/17/2020
3.0.3 1,373 1/7/2020
3.0.2 3,889 12/11/2019
3.0.1 4,696 11/22/2019
3.0.0 4,797 10/24/2019
2.2.7 10,513 11/11/2019
2.2.6 2,568 9/20/2019
2.2.5 1,284 9/5/2019
2.2.4 1,599 8/22/2019
2.2.3 1,429 8/7/2019
2.2.2 4,085 7/15/2019
2.2.1 2,264 6/20/2019
2.2.0 1,661 6/10/2019
2.1.5 1,596 4/28/2019
2.1.4 1,326 4/12/2019
2.1.3 1,471 3/28/2019
2.1.2 1,345 3/14/2019
2.1.1 4,692 3/6/2019
2.1.0 1,753 1/25/2019
2.0.5 1,473 12/19/2018
2.0.4 4,387 12/6/2018
2.0.3 1,607 11/22/2018
2.0.2 1,470 11/14/2018
2.0.1 1,609 10/25/2018
2.0.0 1,680 9/29/2018
1.5.0.4 2,611 8/20/2018
1.5.0.3 2,038 6/8/2018
1.5.0.1 1,899 5/1/2018

New Features
- Export Excel files with shapes to pdf.
- Cut/copy ranges between different workbooks.
- Copy/move worksheet between different workbooks.
- Control whether to adjust page breaks after inserting/deleting rows/columns.
- Customize the row/column/cell delemiter when loading or saving csv file.
- Set the tail repeated rows and right repeated columns when saving to pdf.
- Support for paste options during copy and paste ranges.
- Support IRange.Find() and IRange.Replace() methods.
- Show or hide different kinds of pivot table styles.
- Support for exporting pivot table styles to pdf.
- Support setting the number format for each pivot field.
- Japanese ruby can now be preserved after Excel I/O.
- Get and customize each page settings before saving to pdf file.
- Render any sheet range inside a pdf file.
- Keep rows/columns togother when saving to pdf.
- Save multiple workbooks to one pdf file.
- Export specific pages from spreadsheet to pdf
- Save multiple spreadsheet pages into one pdf page.
- Support IRange.AutoFit method to fit rows/columns.
- Support IRange.FormulaArrayR1C1 property to get or set array formula in R1C1 format.
- Support more import flags during open an Excel file.
- OLEObject will be preserved after Excel I/O.
- Support Shrink to fit, wrapped text while saving to pdf.

Enhancements
- Reference GcPdf v2.2.0.310

Bug Fixed
- GcExcel ignores 'ignore_empty' parameter in TEXTJOIN formula.(DOCXLS-970)
- Large JSON file generated when using ToJson on a particular Workbook.(DOCXLS-968)
- UsedRange.Value sets improper values to the range when Formula is set to Empty.(DOCXLS-956)