search

jandrew / Spreadsheet-XLSX-Reader-LibXML

Read spreadsheet files with xlsx extentions
Other
4 stars 2 forks source link

::Cell does not document how to get to the cell colors #64

Open Tux opened 9 years ago

Tux commented 9 years ago

One can get fgColor/bgColor with $cell->get_fill, but that returns a hash with one entry "patternFill" with two entries fgColor and bgColor each with one entry "indexed" I scanned all modules in this package and found no way to get to the font color (fgColor) or the cell color (bgColor) as RGB or named color, like #00fcab Did I miss something or is this a NYI?

jandrew commented 9 years ago

This is mostly NYI.

As a side note the Microsoft xlsx format does some weird things where it stores applicable formatting for cells and fonts in multiple places. I suspect that in this case method matching ~::ParseExcel will take precedence over matching the Excel application but I havn't put in the cycles yet.