|
|
|
| Come for the quick hacks, stay for the epiphanies. | |
| PerlMonks |
Re: Perl reading excel spreadsheet getting ##### for few columnsby bobn (Chaplain) |
| on May 20, 2004 at 20:42 UTC ( [id://355140]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
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
|
|
||||||||||||||||||||||||