Remove Unused Styles inside the Workbook
Contents
[
Hide
]
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.