Perl Programming Help:
parsing excel, format
Dec 13, 2012, 4:09 AM
I'm trying to parse excel file using Spreadsheet::ParseExcel(::Font) .
it works nice, but I also need format (font colour). problem is, it seems to think format of entire cell is equal to colour of first char in it. I need the colour of last word which differs from rest of cell. how to do it?
edit: I think I found solution using:
my $formats = $oWkC->get_rich_text()
(This post was edited by orange on Dec 14, 2012, 12:38 AM)