DS.Documents.Excel 7.1.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 DS.Documents.Excel --version 7.1.0                

                    
                

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

                    
                

            
#r "nuget: DS.Documents.Excel, 7.1.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 DS.Documents.Excel as a Cake Addin
#addin nuget:?package=DS.Documents.Excel&version=7.1.0

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

Document Solutions for Excel, .NET Edition

Programmatically create Excel .xlsx spreadsheets with ease in your server or desktop applications. Document Solutions for Excel, .NET Edition (DsExcel, formerly 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, Images, JSON, and SpreadJS files
  • 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 DsExcel, 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.

DsExcel comes with a full-featured JavaScript Data viewer control (DsDataViewer).

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

Complete Client-Server Spreadsheet Solution

You can optionally integrate DsExcel 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.

Resources

Other Document Solutions Product

Document Solutions JavaScript Viewer

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 (16)

Showing the top 5 NuGet packages that depend on DS.Documents.Excel:

Package Downloads
C1.Win.C1Document

The ComponentOne Document library for WinForms provides support for creating documents and reports.
C1.Win.Document

The ComponentOne Document library for WinForms provides support for creating documents and reports.
C1.Win.C1Document.Ja

ComponentOne Document library 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
7.2.4 193 10/31/2024
7.2.3 700 10/10/2024
7.2.2 1,891 9/18/2024
7.2.1 1,138 8/30/2024
7.2.0 1,570 8/20/2024
7.1.5 1,021 7/19/2024
7.1.4 334 6/27/2024
7.1.3 430 6/7/2024
7.1.2 429 5/16/2024
7.1.1 374 4/29/2024
7.1.0 3,838 4/16/2024
7.0.5 277 3/21/2024
7.0.4 1,237 2/29/2024
7.0.3 332 2/7/2024
7.0.2 170 1/19/2024
7.0.1 3,778 1/2/2024
7.0.0 933 12/11/2023

# Changes from version 7.0.5:

## Added
- Enhance Template Language with better performance.(DOCXLS-5722)
- Ignore errors in range.(DOCXLS-8310)
- Support for interrupting execution of ProcessTemplate method.(DOCXLS-8396)
- Template Language supports OverwriteWithFormat under Classic Mode.(DOCXLS-8515)
- Support lossless .sjs/ssjson I/O of GanttSheet.(DOCXLS-8629)
- Support CalculationMode options.(DOCXLS-8750)
- Search cells with tags.(DOCXLS-8759)
- Support multi column sorting in Template Language.(DOCXLS-8818)
- Support custom sort order in Template Language.(DOCXLS-8819)
- Get and set cell background images.(DOCXLS-8829)
- Support table reference in cross workbook formulas.(DOCXLS-8859)
- Export Barcodes as Pictures in Excel files.(DOCXLS-9278)
- Support lossless .sjs/ssjson I/O of ReportSheet.(DOCXLS-9625)

## Fixed
- Exception is thrown on calling ProcessTemplate method when data source is not found.(DOCXLS-5052)
- The grouped result is incorrect after calling ProcessTemplate method when using JSON data source.(DOCXLS-6476)
- The result of SUMIFS formula is incorrect after processing template file.(DOCXLS-6596)
- Exception is thrown on calling ProcessTemplate method when data field is numeric.(DOCXLS-8098)
- The result in the report workbook is incorrect after processing the template file.(DOCXLS-8489)
- The result of SUM formula is incorrect after processing the template file.(DOCXLS-8514)
- The merge area is incorrect after processing the template file.(DOCXLS-8656)
- The result of DIV formula is incorrect after processing the template file.(DOCXLS-8669)
- The cell background color is not expanded as expected in the exported report workbook.(DOCXLS-8709)
- The result of MIN and MAX formula is incorrect after processing the template file.(DOCXLS-8786)
- The calculated result is incorrect in the exported report workbook after processing the template file.(DOCXLS-8834)
- The formula is changed in the exported report workbook after processing the template file.(DOCXLS-9002)
- Exception is thrown on calling ProcessTemplate method.(DOCXLS-9023)
- Performance issue on processing template when setting G=R.(DOCXLS-9041)
- The apply range of conditional format is changed in the exported workbook.(DOCXLS-9046)
- The chart in the exported PDF file is incorrect.(DOCXLS-9579)
- The ISort.Apply() method didn't work as intended.(DOCXLS-9853)
- Performance issue on processing template containing merged cell.(DOCXLS-9961)
- The border is lost in the exported XLSX file.(DOCXLS-10015)
- Image is lost in the exported XLSX file when PaginationMode is true.(DOCXLS-10020)
- The row/column header caption in Pivot Table is lost in the exported XLSX file.(DOCXLS-10044)
- Exception is thrown on loading particular SSJSON file.(DOCXLS-10047)
- Exception is thrown on loading particular SJS file.(DOCXLS-10084)
- The result of the DATEVALUE formula is incorrect.(DOCXLS-10085)
- Performance issue on processing template when there're too many sheets.(DOCXLS-10088)
- The table formula is not expanded correctly when calling ProcessTemplate method.(DOCXLS-10090)
- Exception is thrown on loading worksheet from JSON containing non-existent external references.(DOCXLS-10092)