Spire.XLS for Python 15.5.0 现已正式发布。最新版本支持给 shape 分组。此外，本次更新还修复了一些已知问题，例如将 chart 保存为 image 时，程序报"SpireException: Arg_InvalidCastException"错的问题。详情查看下列内容。

新功能:

• 支持对 Shape 分组。

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()

• 支持替换字体。

wb = Workbook()
wb.LoadFromFile(inputFile)

sheet = wb.Worksheets[0]

# Create a cell style and set the color
style = wb.Styles.Add("Mystyle")
style.Font.FontName = "Arial"

style2 = wb.Styles.Add("Mystyle1")
style2.Font.FontName = "Times New Roman"

style3 = wb.Styles.Add("Mystyle2")
style3.Font.FontName = "宋体"

wb.Worksheets[0].ReplaceAll("Brillux", style,"e-iceblue", style2)
wb.Worksheets[0].ReplaceAll("3342sdf",style,  "问题内容", style3)
wb.SaveToFile(outputFile)
wb.Dispose()

• 支持自定义数据透视表字段名称。

workbook = Workbook()
workbook.LoadFromFile(inputFile)
sheet = workbook.Worksheets.get_Item("Tabular Pivot")
table = sheet.PivotTables.get_Item(0)
table.PivotFields[1].CustomName = "fieldName1"
table.PivotFields[2].CustomName = "fieldName2"
table.RowFields[0].CustomName = "rowName"
table.ColumnFields[0].CustomName = "colName"
table.PivotFields[0].CustomName = "fieldName0"
table.DataFields[0].CustomName = "DataName"
table.CalculateData()
workbook.SaveToFile(outputFile, ExcelVersion.Version2013)
workbook.Dispose()

• 支持开启修订模式。

workbook = Workbook()
workbook.LoadFromFile(inputFile)
workbook.TrackedChanges(True);
workbook.SaveToFile(outputFile, ExcelVersion.Version2013);
workbook.Dispose()

• 支持嵌入图片到单元格。

workbook = Workbook()
workbook.LoadFromFile(inputFile)
sheet = workbook.Worksheets[0]
sheet.Range["D1"].InsertOrUpdateCellImage(inputFile_Img,True)
workbook.SaveToFile(outputFile,ExcelVersion.Version2013)
workbook.Dispose()

调整：:

• 升级 SkiaSharp->3.116.1
• 新增支持 Linux ARM 平台

问题修复:

• 修复了将 chart 保存到 image 时，程序报 “SpireException: Arg_InvalidCastException” 错的问题。
• 修复了加载特定 XLSM 文档时，程序报 “SpireException: Arg_NullReferenceException” 错的问题。
• 修复了加载特定 XLSX 文档时，程序报 “Arg_IndexOutOfRangeException” 错的问题。

https://www.e-iceblue.cn/Downloads/Spire-XLS-Python.html