Home: Perl Programming Help: Beginner:
parsing excel, format


Dec 13, 2012, 4:09 AM

Views: 1135
parsing excel, format

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)