Write more than 1 million records into excel sheet

satyawan has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Write more than 1 million records into excel sheet by Corion (Patriarch) on Dec 02, 2011 at 08:13 UTC
Spreadsheet::WriteExcel writes the old Excel format, which can only store 65536 rows because Excel can only handle 65536 rows. Maybe take a look at Excel::Writer::XLSX.	[reply]
Re^2: Write more than 1 million records into excel sheet by satyawan (Initiate) on Dec 02, 2011 at 09:06 UTC
Yes.. by Excel::Writer::XLSX it's possible. I tried to install the package Excel::Writer::XLSX on my linux machine.But it's giving me an error of Perl v5.10.0 required--this is only v5.8.6, stopped at Makefile.PL line 7. Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install Please help..	[reply]
Re^3: Write more than 1 million records into excel sheet by Corion (Patriarch) on Dec 02, 2011 at 09:34 UTC
What part of `Perl v5.10.0 required` [download] Is unclear to you? You will either need to upgrade the version of Perl you are using or need to find out what parts of the module actually need Perl 5.10 and whether you might get along by using an unsupported version of Perl.	[reply] [d/l]
Re^4: Write more than 1 million records into excel sheet by satyawan (Initiate) on Dec 02, 2011 at 10:10 UTC
Re^5: Write more than 1 million records into excel sheet by Corion (Patriarch) on Dec 02, 2011 at 12:30 UTC
Re^3: Write more than 1 million records into excel sheet by jmcnamara (Monsignor) on Dec 02, 2011 at 11:45 UTC
There is a perl 5.8.2 version of Excel::Writer::XLSX that is up to date with the latest version on CPAN available on this branch on GitHub. It will probably become the main CPAN release in a week or so. Update: As of CPAN version 0.38 Excel::Writer::XLSX now supports perl 5.8.2. P.S. If you are writing a million records you will probably want to turn on the set_optimization option. Update: Perl 5.8.2 is now supported in Excel::Writer::XLSX >= version 0.38. -- John.	[reply]
Re: Write more than 1 million records into excel sheet by Ratazong (Monsignor) on Dec 02, 2011 at 08:12 UTC
It works with Win32::OLE and Excel 2007. See Using Win32::OLE and Excel - Tips and Tricks on how to use it. Be aware that it only works in a Windows environment, and it requires Excel to be installed. HTH, Rata	[reply]