删除工作簿中的未使用样式
Contents
[
Hide
]
Excel文件中未使用的样式不仅占用空间,而且在转换为PDF、HTML等不同格式时会导致性能问题。Aspose.Cells提供Workbook.removeUnusedStyles()来移除工作簿内的所有未使用样式。
在工作簿内移除未使用的样式
以下代码解释了Workbook.removeUnusedStyles()的用法。该代码加载了您可以从提供的链接下载的模板Excel文件。它包含一个名为AsposeStyle的未使用样式,此样式和所有其他未使用样式将在执行代码后被移除。请参阅以下屏幕截图以获取更多说明。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
String dataDir = Utils.getDataDir(RemoveUnusedStyles.class); | |
String inputPath = dataDir + "Styles.xlsx"; | |
String outputPath = dataDir + "Output.xlsx"; | |
Workbook workbook = new Workbook(inputPath); | |
workbook.removeUnusedStyles(); | |
workbook.save(outputPath); | |
System.out.println("File saved " + outputPath); |