Just another Perl shrine | |
PerlMonks |
Re: Perl reading excel spreadsheet getting ##### for few columnsby bobn (Chaplain) |
on May 21, 2004 at 00:42 UTC ( [id://355140]=note: print w/replies, xml ) | Need Help?? |
I never had much luck with the OLE approach. When I wanted to parse a bunch of spreadsheets, I ended up going to CPAN and found:
Spreadsheet::ParseExcel::Simple
and that did the trick nicely. Expecially because you can use it anywhere the spreadseet files hapen to be - doesn't have to be on Windoze.
--Bob Niederman, http://bob-n.com All code given here is UNTESTED unless otherwise stated.
In Section
Seekers of Perl Wisdom
|
|