Read the excel style name from an Excel file

Topics: Developer Forum
Jul 24, 2013 at 2:14 AM
I would like to extend the HTML writer to write tables that are embeddable into our website. I think the best way to do this is (in theory) would be to create an excel template with built-in styles and then then use PHPExcel's HTML writer to add the appropriate classes based on these styles. However, I can't find a way to get the Excel cell style name from PHPExcel - is this something that is possible?

Many thanks for any suggestions.
Jul 24, 2013 at 8:31 AM
As far as I'm aware, Excel style names aren't maintained in Excel files, but only in the Excel GUI; as such, they aren't available in PHPExcel
Jul 25, 2013 at 6:03 PM
Thanks Mark. That's really annoying! In our case, the styles are accessible via Macros so I'll probably write a Macro to do the export since we need a pretty limited set of styling features that we must designate by class names.