in reply to only 16383 rows in Spreadsheet::ParseExcel

Excel can export its data in CSV-format by itself, so you would not necessary need Spreadsheet::ParseExcel to do it.

Still if you want to do it through Perl, you could think of using Win32::OLE to control Excel from Perl, but you do need to have Excel installed on the target machine.

For a moment I thought one could also use DBD::Excel or XML::Excel but as they are based upon Spreadsheet::ParseExcel you will hit the same limitations.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

  • Comment on Re: only 16383 rows in Spreadsheet::ParseExcel