Remove Unused Styles inside the Workbook

Unused styles in excel file not only takes space but also cause performance issues while converting to different formats like PDF, HTML, etc. Aspose.Cells provides the Workbook.removeUnusedStyles() to remove all the 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);