in reply to Perl reading excel spreadsheet getting ##### for few columns

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.

  • Comment on Re: Perl reading excel spreadsheet getting ##### for few columns