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 average of each column sheet.Range["B8"].Formula = "=BYCOL(B2:B7, LAMBDA(col, AVERAGE(col)))"; |
| New feature | SPIREXLS-5980 | Added support for converting a specified cell range to HTML.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); Worksheet sheet = workbook.Worksheets[0]; CellRange cell = sheet.Range["A1:B3"]; string html = cell.HtmlString; File.WriteAllText(outputFile, html); |
| New feature | SPIREXLS-5983 | Added support for transposing rows and columns when copying a cell range.
CopyRangeOptions options = CopyRangeOptions.Transpose | CopyRangeOptions.All; sheet["A1:C4"].Copy(sheet["D2:G3"], options); sheet["A1:B5"].Copy(sheet["D5"], options); workbook.SaveToFile(outputFile); |
| New feature | SPIREXLS-6018 | Added support for converting Excel files to PDF/UA-compliant documents.
Workbook workbook = new Workbook(); workbook.LoadFromFile(inputFile); workbook.ConverterSetting.PdfConformanceLevel = Spire.Xls.Pdf.PdfConformanceLevel.Pdf_UA1; workbook.SaveToFile(outputFile, FileFormat.PDF); workbook.Dispose(); |
| Bug | SPIREXLS-6044 | Fixed an issue where OLE objects in the document could not be deleted successfully. |
Click the link to download Spire.XLS 16.1.4:
More information of Spire.XLS new release or hotfix:
