Spire.XLS 7.5.5

.NET Framework 2.0
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Spire.XLS --version 7.5.5
NuGet\Install-Package Spire.XLS -Version 7.5.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="Spire.XLS" Version="7.5.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Spire.XLS --version 7.5.5
#r "nuget: Spire.XLS, 7.5.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 Spire.XLS as a Cake Addin
#addin nuget:?package=Spire.XLS&version=7.5.5

// Install Spire.XLS as a Cake Tool
#tool nuget:?package=Spire.XLS&version=7.5.5

Spire.XLS for .NET is a professional .NET Excel component to enables developers to generate, write, edit and save Excel files with C# and Visual Basic in .NET 2.0, .NET 3.5, .NET 4.0, .NET 4.0 ClientProfile, and .NET 4.5
Spire.XLS for .NET also enables developers to convert Excel to other popular formats, such as PDF, XML, HTML, CSV, Image format etc. And, it supports developers to export data from database to Excel or import data from Excel to datatable.
With Spire.XLS for .NET, developers can create any types of ASP.NET web responses and WinForms applications to operate Excel files.

Product Compatible and additional computed target framework versions.
.NET Framework net20 is compatible.  net35 is compatible.  net40 is compatible.  net40-client is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
7.6.54 254 4/20/2015
7.6.43 294 3/20/2015
7.6.33 669 2/11/2015
7.6.21 17,863 12/15/2014
7.6.1 517 10/11/2014
7.5.19 165 9/26/2014
7.5.17 135 9/18/2014
7.5.16 120 9/11/2014
7.5.12 177 8/26/2014
7.5.7 205 8/15/2014
7.5.5 177 7/22/2014
7.5.3 157 7/9/2014
7.5.0 115 6/25/2014
7.4.16 94 6/19/2014
7.4.13 97 6/10/2014
7.4.9 82 5/30/2014
7.4.0 116 4/28/2014
7.3.12 91 4/18/2014
7.3.2 582 3/13/2014
7.0.0 173 3/2/2013

Spire.XLS 7.5.5

New features:
Add new feature to read value in cell of pivot table.
Add new feature to fold and unfold the fields of pivot table.
Add new feature to insert few blank rows as a header rows in the sheet in which pivot table is created.

Bug solutions:

Fix the issue that the shape is lost when loading and saving .xlsx file.
Fix the error "Specified argument was out of the range of valid values" occurred when converting excel to pdf.
Fix the error "Arithmetic operation resulted in an overflow." occurred when saving .xls file.
Fix the issue that it took a long time to calculation all value of excel file.
Fix the error "unknown formula IFERROR" occurred when getting the value of ACCRINT formula using FormulaStringValue method.

Spire.XLS 7.5.3
Add a new feature to auto fit all columns of pivot table.
Add a new feature to set "Enable show details", "Refresh data when opening the file" for data of Pivot table.
Add a new feature to print Excel file.
Fix the issue that all icons of conditional formatting were lost when opening and saving .xlsx file.
Fix the issue that auto fit function didn't work in converting Excel to PDF.

Spire.XLS 7.5
Fix the error "Arithmetic operation resulted in an overflow" occurred when copying data from a sheet to another sheet of the same workbook.

Spire.XLS 7.4.16
Fixed the bug that the position of some icons in the html file converted from excel file is incorrect.
Fixed the issue that CheckState property of CheckBox doesn't work.
Fixed the issue that secondary axis for a line chart object is not able to be initialized.

Spire.XLS 7.4.13
Add new feature to add report filter in pivot table.

Fixed the error that "A disk error occurred during a write operation." when loading an .xls file from memory stream into the pdfConverter.
Fixed the error that "Unable to read beyond the end of the stream." when loading an .xls file.


Spire.XLS 7.4.9
New Features:
Add new feature to convert PivotTable to PDF.
Add new feature to insert row with the style of previous row to excel, sheet.InsertRow(rowIndex,rowCount, InsertOptionType);.
Bug Solutions:
Fix the issue that Worksheet.AutoFitRow() method doesn't work.
Resolved wrong index issue in DeleteRow(index, count) method.
Fix the issue that dynamic (formula calculated) data was not correctly after added to the chart.
Fix the issue that the PivotTable data was not refreshed.
Fix the borders missing issue after protecting the excel file with a password.
Fix the issue that workbook.DataSorter.Sort() method doesn't work.
Fix wrong page number in Image converted from excel file.
Fix the error "Requested value 'vertical' was not found" caused while loading excel file.
Fix the wrong format of date in HTML converted from excel files.
Fix that data bar missing issue in PDF converted from excel files.
Fix the superscript and subscript missing issue in Html converted from excel files.
Fix the error "Object reference not set to an instance of an object" when executing the line workbook.CreatePivotStyle();
Fix the issue that the data of cell is truncated in Html file converted from excel file.
Fix the issue AutoFitColumns() method doesn't work for the merged cells.
Fix the issue that Worksheet.SaveAsHtml() method is not calculating formulas in output html file.
Fix the error "Requested value 'vertical' was not found" caused when deleting row from excel file.


Spire.XLS 7.4
Add a new feature to show totals in a pivot table as percentage of totals.

Spire.XLS 7.3.12 New feature and bug solutions.

Add a new feature to get the page count of excel file and the row and column number of page break.
• Fix the format is missing issue when filling data into cell range.
• Fix the sheet still can be edited when set the property SheetProtectionType.Objects
• Fix some content is missing issue in converted Image from Excel.


In this new version, we updated the feature of converting Excel to PDF. With this enhancement, more elements in Excel file can be converted to PDF successfully, such as chart, shape, smart art and etc.

And the .xlsb, ods formats starts to support by Spire.XLS.