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



orange
User

Dec 13, 2012, 4:09 AM


Views: 1044
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?
thanks.

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)