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 i==1: workbook.DataSorter.SortColumns.Clear() workbook.DataSorter.SortColumns.Add(1, SortComparsionType.BackgroundColor, OrderBy.Bottom) workbook.DataSorter.SortColumns.Add(2, SortComparsionType.BackgroundColor, OrderBy.Top) workbook.DataSorter.Sort(worksheet.Range["A1:E7"]) elif i==2: workbook.DataSorter.SortColumns.Clear() workbook.DataSorter.SortColumns.Add(1, SortComparsionType.FontColor, OrderBy.Top) workbook.DataSorter.SortColumns.Add(3, SortComparsionType.FontColor, OrderBy.Bottom) workbook.DataSorter.Sort(worksheet.Range["A1:E7"]) elif i==3: workbook.DataSorter.SortColumns.Clear() workbook.DataSorter.SortColumns.Add(5, SortComparsionType.Icon, OrderBy.Top) workbook.DataSorter.SortColumns.Add(6, SortComparsionType.Icon, OrderBy.Bottom) workbook.DataSorter.Sort(worksheet.Range["A1:G8"]) elif i==4: workbook.DataSorter.SortColumns.Clear() workbook.DataSorter.SortColumns.Add(0, SortComparsionType.Values, OrderBy.Ascending) workbook.DataSorter.SortColumns.Add(2, SortComparsionType.BackgroundColor, OrderBy.Bottom) workbook.DataSorter.SortColumns.Add(3, SortComparsionType.FontColor, OrderBy.Bottom) workbook.DataSorter.SortColumns.Add(5, SortComparsionType.Icon, OrderBy.Top) workbook.DataSorter.Sort(worksheet.Range["A1:G7"]) workbook.SaveToFile(outputFile, ExcelVersion.Version2016) workbook.Dispose() |
| Bug | SPIREXLS-5799 | Fixes the issue where errors occurred when opening, loading, or saving documents. |
| Bug | SPIREXLS-5836 | Fixes the issue where formulas were calculated incorrectly. |
| Bug | SPIREXLS-5859 | Fixes the issue where formula references were incorrect when copying cells. |
| Bug | SPIREXLS-5867 | Fixes the issue where an "Invalid column index" error occurred when moving cells using Worksheet.Move. |
Click the link to download Spire.XLS for Python 15.7.1:
