How to Set Table Style

Topics: User Forum
Feb 2, 2015 at 1:02 AM
Are the "Table Styles" in MS Excel available for use on PHPExcel such as "Table Style Medium 2" that set alternating row colors, font, background header color, etc. such that I can set all cells in a sheet at once? If so, how do I set it? Or, are these styles a collection of settings and conditional settings that I would have to set up and apply myself? If I have to do it myself, how can I see, in MS Excel, what all these settings are?

Thanks much
chuck
Coordinator
Feb 2, 2015 at 8:18 AM
Table styles are simply a collection of settings for different "elements" of a table: heading row, even row, odd row, summary row, etc.

These collections are built into the Excel GUI, so they're not stored in the file as a collection in any way, simply as the style that is applied to a particular cell, no different to the way you'd apply to an individual cell yourself