Problem with Excel.Styles collection


I’m using Aspose.Excel to scan a template .xls file and extract certain information about it, including named ranges, worksheets, etc.

One of the pieces of info that i need is the name of each of the styles in the workbook. I thought this would be pretty straightforward using the Excel.Styles collection, but when I load the .xls worksheet, the Styles.Count shows 0. It’s not loading the styles from the workbook.

Any suggestions?


The Styles collection is only used to set styles at run time. It doesn’t retrieve styles in your designer file.