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 474 10/10/2024
7.2.2 676 9/18/2024
7.2.1 2,806 8/30/2024
7.2.0 2,042 8/20/2024
7.1.5 5,328 7/19/2024
7.1.4 707 6/27/2024
7.1.3 1,309 6/7/2024
7.1.2 651 5/16/2024
7.1.1 7,147 4/29/2024
7.1.0 1,940 4/16/2024
7.0.5 2,742 3/21/2024
7.0.4 3,159 2/29/2024
7.0.3 2,593 2/7/2024
7.0.2 1,057 1/19/2024
7.0.1 4,777 1/2/2024
7.0.0 2,225 12/11/2023
6.2.5 10,985 11/21/2023
6.2.4 2,544 11/3/2023
6.2.3 3,645 10/13/2023
6.2.2 5,573 9/15/2023
6.2.1 1,351 8/25/2023
6.2.0 4,381 8/7/2023
6.1.4 1,937 7/21/2023
6.1.3 5,715 7/7/2023
6.1.2 5,289 6/16/2023
6.1.1 5,305 5/26/2023
6.1.0 9,070 5/8/2023
6.0.6 7,169 4/7/2023
6.0.5 6,513 3/17/2023
6.0.4 21,504 2/24/2023
6.0.3 5,637 2/3/2023
6.0.2 4,300 1/6/2023
6.0.1 2,909 12/23/2022
6.0.0 2,837 12/12/2022
5.2.5 86,610 11/24/2022
5.2.4 1,988 11/4/2022
5.2.3 13,847 10/13/2022
5.2.2 12,717 9/16/2022
5.2.1 1,504 8/26/2022
5.2.0 2,328 8/15/2022
5.1.5 3,705 7/26/2022
5.1.4 4,371 7/7/2022
5.1.3 5,286 6/16/2022
5.1.2 2,895 5/27/2022
5.1.1 1,884 5/7/2022
5.1.0 5,238 4/20/2022
5.0.5 6,007 3/23/2022
5.0.4 5,395 3/4/2022
5.0.3 6,398 2/11/2022
5.0.2 1,824 1/14/2022
5.0.1 3,649 12/26/2021
5.0.0 12,222 12/13/2021
4.2.6 119,077 11/23/2021
4.2.5 3,093 11/5/2021
4.2.4 1,216 10/15/2021
4.2.3 1,076 9/27/2021
4.2.2 979 9/24/2021
4.2.1 2,284 9/3/2021
4.2.0 3,704 8/16/2021
4.1.4 1,184 7/29/2021
4.1.3 18,560 7/9/2021
4.1.2 4,150 6/15/2021
4.1.1 1,998 5/20/2021
4.1.0 5,008 4/28/2021
4.0.5 1,262 4/9/2021
4.0.4 2,948 3/8/2021
4.0.3 1,692 1/29/2021
4.0.2 12,923 1/7/2021
4.0.1 1,921 12/9/2020
4.0.0 4,206 11/20/2020
3.2.4 7,632 10/30/2020
3.2.3 5,333 9/29/2020
3.2.2 2,333 8/28/2020
3.2.1 1,765 8/7/2020
3.2.0 1,362 7/21/2020
3.1.5 1,802 6/19/2020
3.1.4 1,232 6/4/2020
3.1.3 2,563 5/18/2020
3.1.2 6,625 4/28/2020
3.1.1 1,357 4/10/2020
3.1.0 2,718 3/5/2020
3.0.4 2,332 1/17/2020
3.0.3 1,361 1/7/2020
3.0.2 3,876 12/11/2019
3.0.1 4,686 11/22/2019
3.0.0 4,762 10/24/2019
2.2.7 10,429 11/11/2019
2.2.6 2,560 9/20/2019
2.2.5 1,276 9/5/2019
2.2.4 1,587 8/22/2019
2.2.3 1,403 8/7/2019
2.2.2 4,077 7/15/2019
2.2.1 2,255 6/20/2019
2.2.0 1,620 6/10/2019
2.1.5 1,564 4/28/2019
2.1.4 1,316 4/12/2019
2.1.3 1,463 3/28/2019
2.1.2 1,319 3/14/2019
2.1.1 4,415 3/6/2019
2.1.0 1,743 1/25/2019
2.0.5 1,465 12/19/2018
2.0.4 4,375 12/6/2018
2.0.3 1,595 11/22/2018
2.0.2 1,458 11/14/2018
2.0.1 1,597 10/25/2018
2.0.0 1,665 9/29/2018
1.5.0.4 2,598 8/20/2018
1.5.0.3 2,027 6/8/2018
1.5.0.1 1,885 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)