Spire.XLS 8.8.0

Spire.XLS for .NET

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.

There is a newer version of this package available.
See the version list below for details.
Install-Package Spire.XLS -Version 8.8.0
dotnet add package Spire.XLS --version 8.8.0
<PackageReference Include="Spire.XLS" Version="8.8.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Spire.XLS --version 8.8.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Spire.XLS 8.8.0
New features:

   Adds a new method ClearFilter to clear a filter which is not in a pivot table.
   1
    AutoFiltersCollection filter = workbook.Worksheets["Sheet2"].AutoFilters;
   2
    filter.ClearFilter(int);//filter.ClearFilter(columnName);
   3
    //refresh data
   4
    filter.Filter();Sample code:

Bug Fixes:

   Fixes the issue that the option "Autofit column widths on update" for pivot table changed to be checked after saving.
   Fixes the issue that the text color couldn’t be set for an existing file.
   Fixes the issue that the chart type "Line" changed to "Line Marker" when creating a chart in .xls file.
   Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.
   Fixes the issue that text and lines got overlapped when converting Excel to XPS.
   Fixes the issue that caused a NullReferenceException when saving Excel to PDF.
   Fixes the issue that the format was wrong when converting Excel to PDF.
   Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
9.5.6 263 5/16/2019
9.5.4 222 5/13/2019
9.5.0 500 5/1/2019
9.4.6 1,123 4/15/2019
9.4.0 1,105 4/2/2019
9.3.10 2,112 3/21/2019
9.3.4 501 3/13/2019
9.2.11 1,334 2/27/2019
9.2.8 470 2/21/2019
9.1.22 2,544 2/1/2019
9.1.14 1,392 1/24/2019
9.1.0 1,004 1/10/2019
8.12.11 870 12/28/2018
8.12.3 1,296 12/11/2018
8.11.6 1,479 11/21/2018
8.11.2 736 11/13/2018
8.10.7 1,267 10/31/2018
8.10.2 1,400 10/12/2018
8.9.8 1,279 9/30/2018
8.9.3 821 9/18/2018
8.8.5 1,726 8/29/2018
8.8.1 2,321 8/8/2018
8.8.0 869 8/1/2018
8.7.2 1,117 7/12/2018
8.6.6 811 6/28/2018
8.6.1 618 6/21/2018
8.5.1 2,290 5/11/2018
8.0.0 2,083 2/8/2018
7.12.150 808 2/6/2018
7.12.144 2,077 1/12/2018
7.12.140 823 12/28/2017
7.12.130 797 12/14/2017
7.12.125 803 12/4/2017
7.12.109 1,476 11/7/2017
7.12.100 958 10/23/2017
7.12.90 2,429 9/28/2017
7.12.76 1,661 8/22/2017
7.12.69 768 8/11/2017
7.12.55 2,667 7/18/2017
7.12.43 762 7/3/2017
7.12.27 2,562 6/9/2017
7.12.19 1,154 5/26/2017
7.12.11 1,483 5/9/2017
7.12.7 372 5/4/2017
7.12.0 2,877 4/24/2017
7.11.59 3,484 2/28/2017
7.11.49 2,246 1/24/2017
Show less