Spire.XLS 7.12.100

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 7.12.100
dotnet add package Spire.XLS --version 7.12.100
<PackageReference Include="Spire.XLS" Version="7.12.100" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Spire.XLS --version 7.12.100
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Spire.XLS 7.12.100
Adds TimePeriodType enum to specify the time period
Adds ConditionalFormatWrapper/XlsConditionalFormat.SetTimePeriod(TimePeriodType timePeriod) to format only cells with dates occurring in a specific time period.
Fixes the issue where accounting Number Format didn't work correctly while saving Excel to PDF.
Fixes the issue that caused the invalid column index exception while saving Excel to PDF.
Resolves the issue where the comma that is not an actual field separator was considered as delimiter while saving Excel to CSV.
Fixes the issue that caused the back color of ConditionalsFormat incorrect.
Fixes the issue that caused the OverFlowException while loading an Excel file.

Spire.XLS 7.12.90
Supports to add shapes to worksheet.
Supports to set OLE size.
Fixes the issue that the result document changed to Protected View after saving .xlsx to .xls.
Fixes the issue that caused ArgumentOutOfRangeException when converting Excel to HTML.
Fixes the issue that caused the style of the chart missing when using SaveChartAsImage method.
Fixes the issue that caused the font changed when converting Excel to PDF.
Fixes the issue that caused the data format incorrect when converting Excel to pdf.
Fixes the issue that caused the formal result wrong in French environment.
Fixes the issue that caused result incorrect when getting the validation formula value.
Resolves the issue that caused Euro (€) sign lost when using DisplayedText property.
Fixes the issue that the value in the original cell range changed along with value which was set by range.Text property in the copied range.
Fixes the issue that caused IndexOutOfRangeException when loading file.
Fixes the issue that caused the process hanging when converting Excel to PDF.
Fixes the issue that caused the value type changed from text to number when importing data from datatable to Excel.
Fixes the issue that the method AutoFitColumns didn't work.

Spire.XLS 7.12.76

Spire.XLS supports to save file to Excel2016 format.
Fixes the issue that caused XmlException when using CalculateAllValue() method.
Fixes the issue that caused wrong result of formulas while the computer sets the region as France and language as French.
Fixes the issue that caused warning message "We found a problem with some content in ... Do you want us to try recover as much as we can?" when opening the saved file.
Fixes the issue that caused wrong size of the image when scaling the inserted image.
Fixes the issue that caused FormatException when loading an .xlsm file.


Spire.XLS 7.12.69

Fixes the issue that caused stretched image when converting Excel to PDF while the computer sets the region as Spain and language as Chile.
Fixes the issue that caused chart missing when converting Excel to PDF.
Fixes the issue that caused black background when saving Excel worksheet to pdf.
Fixes the issue that the setting "comment.AutoSize = true" doesn't work.
Fixes the issue that caused ArgumentException when loading .xlsm file.
Fixes the issue that caused slicer missing when saving .xlsm file.


Spire.XLS 7.12.55
Fixes the issue that caused wrong pagination when converting Excel to PDF.
Fixes the issue that caused graph missing when converting Excel to PDF.
Fixes the issue that the images are rotated when converting Excel to PDF.
Fixes the issue where the position of the shapes are wrong when converting Excel to PDF.
Fixes the issue that caused XmlException when loading Excel file.

Spire.XLS 7.12.43

Fixes the issue that caused wrong content when converting to PDF.
Fixes the issue that the value in tag was incorrect after protecting cell.
Fixes the issue that the displaying way for the value of the data labels in chart changed from two lines to one line after converting Excel to PDF.
Fixes the issue that caused content missing when adding watermark.
Fixes the issue that the image in Group cannot be extracted.
Fixes the issue that the hidden row was visible on HTML when converting to HTML.
Fixes the issue that caused wrong value "#NAME" after using the InsertDataTable method.
Fixes the issue that caused exception "Workbook is protected and password wasn't specified." yet the document doesn't have opening password when load.
Fixes the issue that caused GDI+ exception after adding picture.


Spire.XLS 7.12.27
Add custom properties to Excel documents.
Fixes the issue that caused XmlException when SaveAsImage method was invoked.
Fixes the issue that the data in the shape isn't updated after editing.
Fixes the issue that the result PDF converted from Excel prompts message "Cannot extract the embedded font 'FAACFG+ArialMT'. Some characters may not display or print correctly.".
Fixes the issue that caused ArgumentOutOfRangeException when loading files.


Spire.XLS 7.12.19
Fixes the issue that the position of the datalabel cannot be changed.
Fixes the issue that caused the process hanging when using the GetSplitPageInfo method.
Fixes the issue that caused wrong value when copying range.
Fixes the issue that caused "spr2380 was unhandled" exception when using CalculateAllValue.
Improves the function of converting Excel to PDF.
Fixes the issue that caused exception when using multi-thread to load document.

Spire.XLS 7.12.11
Fixes the issue that caused KeyNotFoundException when merging multiple excel documents.

Spire.XLS 7.12.7

Fixes the issue that caused NullReferenceException when using InsertRow method.
Fixes the issue that caused incorrect result when getting validation formula.
Fixes the issue that caused ArgumentOutOfRangeException when using CalculateAllValue mehtod.
Fixes the issue that caused wrong date format when getting the data.
Fixes the issue that caused icon missing when converting Excel to image.
Improves the conversion from Excel to PDF.

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
9.5.6 123 5/16/2019
9.5.4 196 5/13/2019
9.5.0 494 5/1/2019
9.4.6 1,109 4/15/2019
9.4.0 1,050 4/2/2019
9.3.10 2,056 3/21/2019
9.3.4 498 3/13/2019
9.2.11 1,317 2/27/2019
9.2.8 467 2/21/2019
9.1.22 2,517 2/1/2019
9.1.14 1,391 1/24/2019
9.1.0 993 1/10/2019
8.12.11 864 12/28/2018
8.12.3 1,296 12/11/2018
8.11.6 1,472 11/21/2018
8.11.2 736 11/13/2018
8.10.7 1,264 10/31/2018
8.10.2 1,395 10/12/2018
8.9.8 1,277 9/30/2018
8.9.3 818 9/18/2018
8.8.5 1,725 8/29/2018
8.8.1 2,312 8/8/2018
8.8.0 868 8/1/2018
8.7.2 1,109 7/12/2018
8.6.6 811 6/28/2018
8.6.1 618 6/21/2018
8.5.1 2,271 5/11/2018
8.0.0 2,080 2/8/2018
7.12.150 807 2/6/2018
7.12.144 2,074 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,475 11/7/2017
7.12.100 958 10/23/2017
7.12.90 2,425 9/28/2017
7.12.76 1,659 8/22/2017
7.12.69 768 8/11/2017
7.12.55 2,665 7/18/2017
7.12.43 762 7/3/2017
7.12.27 2,562 6/9/2017
7.12.19 1,153 5/26/2017
7.12.11 1,483 5/9/2017
7.12.7 371 5/4/2017
7.12.0 2,857 4/24/2017
7.11.59 3,482 2/28/2017
7.11.49 2,235 1/24/2017
Show less