Spire.XLS 16.3.6 supports manipulating the VBA Macro Project
2026-03-27 06:25:20
We're pleased to announce the release of Spire.XLS 16.3.6. This version supports manipulation of the VBA Macro Project and the Data Simulation Analysis (Scenario Manager). Besides, it also fixes an issue where macros were lost when copying worksheets. More details are shown below. Here is a list of changes made in this release Category ID Description New Feature SPIREXLS-938 SPIREXLS-5995 Added support for VBA Macro Project manipulation, covering creation, reading, modification, and deletion. Adding VBA project: Workbook workbook = new Workbook(); // Add VBA project to the document IVbaProject vbaProject = workbook.VbaProject; vbaProject.Name = "SampleVBAMacro"; string text = "Encoding before…
Spire.XLS 16.2.4 Adds Support for LET and MAP Functions
2026-02-28 07:32:54
We’re pleased to announce the release of Spire.XLS 16.2.4. This version adds support for the LET and MAP functions. Additionally, several issues related to sorting, conditional formatting, column width display, image conversion, font settings, and Excel-to-PDF conversion have been fixed. More details are listed below. Here is a list of changes made in this release Category ID Description New Feature SPIREXLS-6086 SPIREXLS-6087 Added support for the LET and MAP functions. Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; sheet.Range["C1"].Text = "out"; sheet.Range["C2"].Formula = "=LET(x, 5, y, 10, x + y)"; sheet.Range["C3"].Formula = "=LET(a, 1, b, 2, c, 3, d,…
Spire.XLS 16.1.4 supports converting a specified cell range to HTML
2026-01-23 03:06:32
We're pleased to announce the release of Spire.XLS 16.1.4. This version adds several new features, such as support for converting a specified cell range to HTML and converting Excel files to PDF/UA-compliant documents. Besides, it also fixes an issue where OLE objects in the document could not be deleted successfully. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5948 Added support for the BYROW and BYCOL functions. // Use BYROW to calculate the average of each row sheet.Range["G2"].Formula = "=BYROW(B2:F2, LAMBDA(row, AVERAGE(row)))"; // Use BYCOL to calculate the…
Spire.XLS 15.12 supports customizing export options when converting Excel to Markdown
2025-12-29 07:03:12
We're pleased to announce the release of Spire.XLS 15.12. This version supports customizing export options when converting Excel to Markdown. Furthermore, the .NET 10.0 framework is now supported, while some obsolete frameworks have been removed. Meanwhile, some issues that occurred when converting Excel to PDF or HTML, and calculating formulas have also been successfully fixed. More details are listed below. Here is a list of changes made in this release Category ID Description Adjustment / Removed .NET 2.0, .NET 4.0 ClientProfile, netcoreapp 2.0, and WPF 4.0 ClientProfile; added support for .NET 10.0. New Feature SPIREXLS-5938, SPIREXLS-5975 Supports customizing export options…
Spire.XLS 15.11.3 adds support for exporting equations to MathML and LaTeX
2025-11-28 09:38:32
We're pleased to announce the release of Spire.XLS 15.11.3. This version adds support for exporting equation content to MathML and LaTeX, the XMATCH function, converting Excel to JSON, setting EMF background images, and inserting checkbox effects similar to Office 365. Meanwhile, several issues related to loading Excel documents, converting Excel to PDF, and formula calculations have been successfully fixed. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5977, SPIREXLS-5978 Added support for exporting equation content to MathML and LaTeX. Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); Worksheet sheet =…
Spire.XLS 15.10.3 adds support for reading Office cached cloud fonts by default
2025-10-27 08:52:44
We are delighted to announce the release of Spire.XLS 15.10.3. This version adds support for reading Office cached cloud fonts by default, in addition to system and in-memory fonts. It also adjusts the parameters of the AddDigitalSignature() and IDigitalSignatures.Add() methods, and fixes several known issues to improve the library’s stability and performance. Details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5979 Adds support for reading Office cached cloud fonts by default, besides system font directories and in-memory fonts. Adjustment - Modifies the parameter list of the AddDigitalSignature() and IDigitalSignatures.Add()…
Spire.XLS 15.9.7 supports creating and modifying Equations
2025-09-24 06:10:59
We're pleased to announce the release of Spire.XLS 15.9.7. This version adds a new interface for creating and modifying Equations, and also supports the ISOMITTED, LAMBDA functions. Besides, some issues that occurred when converting Excel to PDF and copying worksheets have been successfully fixed. More details are shown below. Here is a list of changes made in this release Category ID Description Optimization SPIREXLS-5888 Optimizes the time consumption for converting Excel to PDF. Optimization SPIREXLS-5929 Optimizes the time consumption for converting Excel to HTML. New feature SPIREXLS-4316 Adds IXlsEquation Interface to support creating and modifying Equations. Workbook workbook = new…
Spire.XLS 15.8.3 supports FORMULATEXT and PDURATION functions
2025-08-26 06:18:45
We're pleased to announce the release of Spire.XLS 15.8.3. This version adds support for the FORMULATEXT and PDURATION functions. Meanwhile, several issues that occurred when converting Excel to PDF or images, saving workbooks, handling PivotTables, and preserving cell styles have also been successfully fixed. More details are listed below. Here is a list of changes made in this release Category ID Description New Feature SPIREXLS-5800 Supports the FORMULATEXT function. sheet.Range["D2"].Formula = "=FORMULATEXT(B2)"; New Feature SPIREXLS-5895 Supports the PDURATION function. sheet.Range["B2"].Formula = "=PDURATION(2.5%,2000,2200)"; Bug Fix SPIREXLS-5878 Fixed an issue where text line breaks were incorrect when converting Excel to PDF. Bug…
