Remove Unused Styles inside the Workbook
Remove Unused Styles inside the Workbook
The following code explains the usage of Workbook.removeUnusedStyles(). The code loads the template excel file which you can download from the provided link. It contains an unused style named AsposeStyle, this style and all other unused styles will be removed after the execution of the code. Please see the following screenshot for more illustration.
// 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); |