删除工作簿中的未使用样式

Contents
[ ]

下面的代码解释了Workbook.remove_unused_styles()的用法。该代码加载了可以从提供的链接下载的模板Excel文件。它包含一个名为AsposeStyle的未使用样式,此样式和所有其他未使用的样式将在执行代码后被移除。

todo:image_alt_text

from aspose.cells import Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Load template excel file containing unused styles
workbook = Workbook(dataDir + "Template-With-Unused-Custom-Style.xlsx")
# Remove all unused styles inside the template this will also remove AsposeStyle which is an unused style inside the template
workbook.remove_unused_styles()
# Save the file
workbook.save(dataDir + "output_out.xlsx")