CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

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


Dec 13, 2012, 4:09 AM

Views: 1106
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)

Edit Log:
Post edited by orange (User) on Dec 14, 2012, 12:38 AM

Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives