Spire.XLS for Python 15.7.1 supports multi-level sorting and pivot table filters
2025-07-23 09:21:50
We're pleased to announce the release of Spire.XLS for Python 15.7.1. This version introduces support for multi-level sorting and adding filters to pivot tables. It also includes optimization of the namespace structure and resolves several issues related to document handling, formula calculations, and cell operations. More details are listed below. Here are the changes included in this release. Category ID Description Optimization — Optimizes and modularizes the namespace structure. New feature SPIREXLS-5354 Adds support for multi-level sorting. workbook = Workbook() workbook.LoadFromFile(inputFile) for i in range(0, workbook.Worksheets.Count): worksheet = workbook.Worksheets.get_Item(i) if i==0: workbook.DataSorter.SortColumns.Clear() workbook.DataSorter.SortColumns.Add(0, SortComparsionType.Values, OrderBy.Ascending) workbook.DataSorter.SortColumns.Add(1, SortComparsionType.Values, OrderBy.Descending) workbook.DataSorter.Sort(worksheet.Range["A1:E7"]) elif…
Spire.XLS for Python 15.5.0 supports grouping Shapes
2025-05-15 09:41:58
We're pleased to announce the release of Spire.XLS for Python 15.5.0. This version supports grouping Shapes. Besides, some known bugs are fixed successfully, such as the issue where saving a chart to an image caused the program to report a "SpireException: Arg_InvalidCastException" error. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-4191 Supports grouping Shapes. workbook = Workbook() workbook.LoadFromFile(inputFile) worksheet = workbook.Worksheets[0] shape1 = worksheet.PrstGeomShapes[0] shape2 = worksheet.PrstGeomShapes[1] groupShapeCollection = worksheet.GetGroupShapeCollection() groupShapeCollection.Group([shape1, shape2]) workbook.SaveToFile(outputFile, ExcelVersion.Version2013) workbook.Dispose() New feature SPIREXLS-4460 Supports replacing the font. wb = Workbook() wb.LoadFromFile(inputFile) sheet…
Spire.XLS for Python 14.12.0 enhances the conversion from Excel to PDF
2024-12-27 03:10:25
We are delighted to announce the release of Spire.XLS for Python 14.12.0. This version fixes the issue that the text position was incorrect after converting an Excel document to a PDF document. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-5571 Fixes the issue that the text position was incorrect after converting an Excel document to a PDF document. Click the link to download Spire.XLS for Python 14.12.0: https://www.e-iceblue.com/Download/Spire-XLS-Python.html
Spire.XLS for Python 14.9.3 supports determining whether to retain the original page size when converting Excel to PDF
2024-11-25 09:10:55
We are excited to announce the release of Spire.XLS for Python 14.9.3. This version supports determining whether to retain the original page size when converting Excel to PDF. It also enhances the conversion from chart sheets to images. Moreover, some known issues are fixed successfully in this version, such as the issue that an exception was thrown when setting font styles on ubuntu22. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5181 Supports determining whether to retain the original page size when converting Excel to PDF. book =…
Spire.XLS for Python 14.7.3 fix an exception when running on Ubuntu 22
2024-07-30 07:38:22
We're pleased to announce the release of Spire.XLS for Python 14.7.3. This version fixes the issue that an exception was thrown when using some features of Spire.XLS on Ubuntu 22. More details are listed below. Here is a list of changes made in this release Category ID Description Bug - Fix the issue that errors are reported when running on Ubuntu22. Click the link to download Spire.XLS for Python 14.7.3: https://www.e-iceblue.com/Download/Spire-XLS-Python.html
Spire.XLS for Python 14.4.4 supports adding FindAll() method to CellRange
2024-04-30 03:53:22
We are excited to announce the release of Spire.XLS for Python 14.4.4. This version supports adding FindAll() method to CellRange. Besides, some known issues are fixed in this version, such as the issue that retrieving custom font files failed. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5165 Supports adding FindAll() method to CellRange. workbook = Workbook() workbook.LoadFromFile("test.xlsx") sheet = workbook.Worksheets[0] sheet.Range["A1"].FindAll("Hello", FindType.Text, ExcelFindOptions.MatchEntireCellContent) Bug SPIREXLS-5092 Fixes the issue that retrieving custom font files failed. Bug SPIREXLS-5194 Fixes the issue that the program threw spire.xls.common.SpireException:Arg_NullReferenceException when creating a…
Spire.XLS for Python 14.2.2 supports macOS system
2024-03-05 09:45:31
We're pleased to announce the release of Spire.XLS for Python 14.2.2. This latest version of the library now includes support for macOS system and addresses a previously identified issue. More details are as follows. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5002 Supports macOS System. Bug SPIREXLS-5109 Fixes the issue that running an application with Python 3.7 threw the exception "cannot import name 'get_args' from 'typing' ". Click the link below to get Spire.XLS for Python 14.2.2： https://www.e-iceblue.com/Download/Spire-XLS-Python.html
Spire.XLS for Python 13.12.6 adds the custom exception class SpireException
2023-12-28 02:50:05
We are delighted to announce the release of Spire.XLS for Python 13.12.6. This version adds the custom exception class SpireException and changes the ArgumentError class to the SpireException class. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - Adds the custom exception class SpireException and changes the ArgumentError class to the SpireException class. Click the link below to get Spire.XLS for Python 13.12.6: https://www.e-iceblue.com/Download/Spire-XLS-Python.html
