Spire.XLS 7.12.125

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.125
dotnet add package Spire.XLS --version 7.12.125
<PackageReference Include="Spire.XLS" Version="7.12.125" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Spire.XLS --version 7.12.125
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Spire.XLS, 7.12.125"
#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 Spire.XLS as a Cake Addin
#addin nuget:?package=Spire.XLS&version=7.12.125

// Install Spire.XLS as a Cake Tool
#tool nuget:?package=Spire.XLS&version=7.12.125
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Spire.XLS 7.12.125
New feature:
Adds Workbook.GetOleSize method to get the displayed size of an embedded Excel OLE object.

Bug Fixes:
Fixes the issue that caused ArgumentOutOfRangeException error when loading workbook XML document.
Fixes the issue that the address of conditional formatting was gotten incorrectly.
Fixes the issue that the double quote was parsed incorrectly when converting CSV to Excel.
Fixes the issue that caused the docfile has been corrupted error when loading .xls document.
Fixes the issue that caused application to hang when loading document.
Fixes the issue that caused the error that extended format record fontindex field has wrong value when loading document.
Fixes the issue that caused application to hang when saving chart as image.
Fixes the issue that ConditionalFormatWrapper.DataBar.MinPoint didn't work.
Fixes the issue that caused HideItemDetail method to throw exception when there is a blank item.
Fixes the issue that caused NullReferenceException when launching a GarbageCollector.


Spire.XLS 7.12.109
Supports to manipulate more conditional formatting in XlsConditionalFormat and ConditionalFormatWrapper.
Adds ConditionalFormatWrapper.StopIfTrue property to stop processing the current rule when the condition meets.
Fixes the issue that caused the "object reference not set to an instance of an object" error when saving the Excel using custom OTF font to pdf.
Fixes the issue that caused incorrect number format when the thread culture is not invariant culture.
Fixes the issue that caused the Accounting number format pushed the $ symbol outside the cell border when converting to PDF.
Fixes the issue that change the PrimaryCategoryAxis.CategoryType property didn't work when loading an existing chart.
Fixes the issue that caused the ConditionalFormatWrapper.Priority property didn't work.
Fixes the issue that caused the AutoFitColumn method didn't work when the cell contains date time.

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.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Spire.XLS:

Package Downloads
KCore_bfagundes
My personal library to work SAP projects.
JecoreDotNetCommon
ebitoo 前端函数库 测试发布 1
kdb_bfagundes
My personal library to work SAP projects.
ksap_bfagundes
My personal library to work SAP projects.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
11.4.0 2,637 4/7/2021
11.3.4 3,940 3/12/2021
11.2.6 3,904 2/23/2021
11.2.3 1,188 2/8/2021
11.1.0 2,847 1/22/2021
10.12.0 9,694 12/3/2020
10.11.7 3,668 11/18/2020
10.11.2 1,187 11/6/2020
10.10.6 5,067 10/15/2020
10.9.16 2,256 9/28/2020
10.9.0 7,826 9/2/2020
10.8.3 5,586 8/11/2020
10.7.2 10,995 7/8/2020
10.5.7 11,096 5/21/2020
10.4.9 5,823 4/23/2020
10.3.8 4,468 3/26/2020
10.3.0 14,881 3/2/2020
10.2.8 2,044 2/20/2020
10.1.8 8,177 1/21/2020
10.1.1 4,200 1/8/2020
9.12.20 6,023 12/19/2019
9.11.14 5,106 11/26/2019
9.11.2 4,797 11/8/2019
9.10.12 4,211 10/25/2019
9.10.4 6,944 10/11/2019
9.9.13 6,170 9/26/2019
9.9.5 2,713 9/12/2019
9.9.0 3,488 9/2/2019
9.8.11 2,560 8/23/2019
9.8.5 2,184 8/15/2019
9.7.0 5,959 7/11/2019
9.6.12 2,138 7/1/2019
9.6.7 1,658 6/19/2019
9.6.1 2,385 6/6/2019
9.5.11 1,787 5/23/2019
9.5.6 893 5/16/2019
9.5.4 1,898 5/13/2019
9.5.0 1,856 5/1/2019
9.4.6 9,234 4/15/2019
9.4.0 4,091 4/2/2019
9.3.10 9,173 3/21/2019
9.3.4 985 3/13/2019
9.2.11 6,954 2/27/2019
9.2.8 880 2/21/2019
9.1.22 7,682 2/1/2019
9.1.14 2,032 1/24/2019
9.1.0 2,666 1/10/2019
8.12.11 1,868 12/28/2018
8.12.3 1,967 12/11/2018
8.11.6 4,381 11/21/2018
8.11.2 1,314 11/13/2018
8.10.7 3,404 10/31/2018
8.10.2 3,927 10/12/2018
8.9.8 2,074 9/30/2018
8.9.3 1,287 9/18/2018
8.8.5 2,751 8/29/2018
8.8.1 11,906 8/8/2018
8.8.0 1,422 8/1/2018
8.7.2 1,702 7/12/2018
8.6.6 1,719 6/28/2018
8.6.1 1,771 6/21/2018
8.5.1 3,708 5/11/2018
8.0.0 3,149 2/8/2018
7.12.150 2,013 2/6/2018
7.12.144 4,216 1/12/2018
7.12.140 1,269 12/28/2017
7.12.130 1,368 12/14/2017
7.12.125 1,326 12/4/2017
7.12.109 1,993 11/7/2017
7.12.100 1,497 10/23/2017
7.12.90 3,789 9/28/2017
7.12.76 2,579 8/22/2017
7.12.69 1,358 8/11/2017
7.12.55 3,169 7/18/2017
7.12.43 1,176 7/3/2017
7.12.27 3,619 6/9/2017
7.12.19 1,846 5/26/2017
7.12.11 2,097 5/9/2017
7.12.7 767 5/4/2017
7.12.0 6,303 4/24/2017
7.11.59 5,027 2/28/2017
7.11.49 4,579 1/24/2017
Show less