GrapeCity.Documents.Excel 5.1.0

.NET Standard 2.0 .NET Framework 4.6.1
There is a newer version of this package available.
See the version list below for details.
NuGet\Install-Package GrapeCity.Documents.Excel -Version 5.1.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.
dotnet add package GrapeCity.Documents.Excel --version 5.1.0
<PackageReference Include="GrapeCity.Documents.Excel" Version="5.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GrapeCity.Documents.Excel --version 5.1.0
#r "nuget: GrapeCity.Documents.Excel, 5.1.0"
#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.1.0

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

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
.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.2 507 9/16/2022
5.2.1 341 8/26/2022
5.2.0 707 8/15/2022
5.1.5 784 7/26/2022
5.1.4 1,498 7/7/2022
5.1.3 1,216 6/16/2022
5.1.2 1,328 5/27/2022
5.1.1 838 5/7/2022
5.1.0 2,546 4/20/2022
5.0.5 1,664 3/23/2022
5.0.4 1,923 3/4/2022
5.0.3 1,740 2/11/2022
5.0.2 857 1/14/2022
5.0.1 2,119 12/26/2021
5.0.0 5,444 12/13/2021
4.2.6 71,645 11/23/2021
4.2.5 1,064 11/5/2021
4.2.4 498 10/15/2021
4.2.3 327 9/27/2021
4.2.2 267 9/24/2021
4.2.1 670 9/3/2021
4.2.0 2,972 8/16/2021
4.1.4 488 7/29/2021
4.1.3 7,795 7/9/2021
4.1.2 2,212 6/15/2021
4.1.1 929 5/20/2021
4.1.0 2,501 4/28/2021
4.0.5 530 4/9/2021
4.0.4 1,225 3/8/2021
4.0.3 701 1/29/2021
4.0.2 6,895 1/7/2021
4.0.1 1,148 12/9/2020
4.0.0 2,240 11/20/2020
3.2.4 1,778 10/30/2020
3.2.3 2,992 9/29/2020
3.2.2 1,178 8/28/2020
3.2.1 897 8/7/2020
3.2.0 576 7/21/2020
3.1.5 1,042 6/19/2020
3.1.4 479 6/4/2020
3.1.3 1,256 5/18/2020
3.1.2 5,243 4/28/2020
3.1.1 580 4/10/2020
3.1.0 1,938 3/5/2020
3.0.4 1,342 1/17/2020
3.0.3 644 1/7/2020
3.0.2 1,947 12/11/2019
3.0.1 3,787 11/22/2019
3.0.0 2,916 10/24/2019
2.2.7 7,219 11/11/2019
2.2.6 1,775 9/20/2019
2.2.5 499 9/5/2019
2.2.4 837 8/22/2019
2.2.3 659 8/7/2019
2.2.2 2,713 7/15/2019
2.2.1 1,496 6/20/2019
2.2.0 677 6/10/2019
2.1.5 810 4/28/2019
2.1.4 555 4/12/2019
2.1.3 707 3/28/2019
2.1.2 548 3/14/2019
2.1.1 594 3/6/2019
2.1.0 969 1/25/2019
2.0.5 688 12/19/2018
2.0.4 3,608 12/6/2018
2.0.3 838 11/22/2018
2.0.2 697 11/14/2018
2.0.1 835 10/25/2018
2.0.0 841 9/29/2018
1.5.0.4 1,800 8/20/2018
1.5.0.3 1,211 6/8/2018
1.5.0.1 1,032 5/1/2018

# Changes from version 5.0.5:

## Added

- [Pivot Table] Specify 'ShowValuesAs' Option for 'Values' Field.(DOCXLS-738)
- Add Numbers Fit Mode of overflow/mask.(DOCXLS-3696)
- Modify Password of Excel Documents.(DOCXLS-4076)
- [Pivot Table] Support for Calculated Field.(DOCXLS-4211)
- Support JSON data source for template language.(DOCXLS-4359)
- Support for "Show #N/A as an empty cell" in Chart.(DOCXLS-4442)
- Convert Table to Range.(DOCXLS-4601)
- Support CELL function.(DOCXLS-4645)
- CSV Custom Parser.(DOCXLS-5162)
- Support for Pivot table views (JSON I/O).(DOCXLS-5221)
- Import Data Function to Import Table, Range, or Worksheet from Excel Files.(DOCXLS-5276)
- Support for TableSheet (JSON I/O).(DOCXLS-5487)

## Fixed

- Converting the imported Excel to Json breaks all formulas in it.(DOCXLS-3840)
- [Template language]Out of memory exception is thrown on using template in multi-thread.(DOCXLS-4449)
- [Template language]The layout is incorrect in the exported xlsx file when using template with cross table.(DOCXLS-4756)
- [Template language]The result of sum function is incorrect in the exported xlsx file.(DOCXLS-4827)
- [Template language]The cell values are not expected in the exported Excel file.(DOCXLS-4888)
- [Template language]The IF formula is lost in the exported xlsx file.(DOCXLS-5224)
- [Template language]The formula is not expanded correctly in exported xlsx file.(DOCXLS-5239)
- IndexOutOfRangeException is thrown on exporting radar chart to PDF file.(DOCXLS-5262)
- [Template language]The result of sum function is incorrect in the exported xlsx file.(DOCXLS-5485)
- The legend of series is not shown in the exported PDF file if the datapoints of the series are empty.(DOCXLS-5569)
- InvalidFormulaException is thrown on creating table when there is "'" in the table column's name.(DOCXLS-5690)
- Extra characters are exported in data validation in the exported JSON file.(DOCXLS-5734)
- NullReferenceException is thrown on setting series formula which contains bubble size info.(DOCXLS-5751)
- The layout of checkbox list is incorrect in the exported PDF file.(DOCXLS-5754)