GrapeCity.Documents.Excel 5.0.5

.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 5.0.5                

                    
                

            
NuGet\Install-Package GrapeCity.Documents.Excel -Version 5.0.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.0.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.0.5                

                    
                

            
#r "nuget: GrapeCity.Documents.Excel, 5.0.5"
#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=5.0.5

// Install GrapeCity.Documents.Excel as a Cake Tool
#tool nuget:?package=GrapeCity.Documents.Excel&version=5.0.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 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

# Changes from version 5.0.4:

## Fixed

- Bad performance when calculating formulas in a specific Excel file.(DOCXLS-5501)
- The position of the frozen pane is changed after JSON I/O.(DOCXLS-5525)
- The layout of checkbox list in the exported pdf file is different from SpreadJS designer.(DOCXLS-5544)
- Performance is bad when calling method toJSON with particular Excel file.(DOCXLS-5564)
- When the chart is exported to PDF, the pattern fill of the legend symbol is not correct.(DOCXLS-5567)
- The layout of the list object in the exporting pdf is not correct.(DOCXLS-5590)
- The checkbox is unchecked when the cell value is set.(DOCXLS-5624)
- Open csv file with double quote, the records would be lost.(DOCXLS-5639)
- ParseException is thrown on opening particular excel file with threaed comment.(DOCXLS-5643)
- Exception is thrown on setting Workbook.Culture property when workbook contains Hyperlink named style.(DOCXLS-5649)
- Exception is throws when opening loading specific JSON file.(DOCXLS-5656)
- Exception is thrown on calling Workbook.SetLicenseKey method in multi-thread.(DOCXLS-5660)
- The result of IRange.LastColumn is not correct in some Excel file.(DOCXLS-5668)
- The plot area of chart is not updated in the exported pdf file when enabling/disabling calculation.(DOCXLS-5682)
- Custom named style are not exported to JSON or Excel file if it is not used in any range.(DOCXLS-5683)
- Font "Noto Sans JP" is not shown correctly in the exported pdf.(DOCXLS-5701)
- Exception is thrown on opening an Excel file.(DOCXLS-5704)
- Exception is thrown on opening an Excel file with ActiveX control.(DOCXLS-5706)
- NullPointerException is thrown on calling Calculate method after loading JSON file.(DOCXLS-5709)