Reading the formatting of the cells (color/fontSize/etc)

[BenjaBobs]

Hi, is there currently any way to read the color/fontSize/etc formatting of a cell?
And if not, are there plans to support it?

My challenge is that I work with excel files that have arbitrarily defined tables with "sections" and "sub sections", and they're always created in widely different ways.
Here's an example of what it could look like:

I was hoping to be able to create some kind of heuristic based on the font size and maybe font color so I can identify which rows are section headers.

[boginw]

Some functionality already exists for this, but it isn't released yet for some reason. See IExcelDataReader.cs#L81 and implementation in ExcelDataReader.cs#L163. They are returning CellStyles which might solve some of your issues. I can see that for your case, the library is missing fore- and background color properties and perhaps border information.