Re: Write more than 1 million records into excel sheet

Replies are listed 'Best First'.
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
I checked the version of perl. But it's shwoing me two versions. -sh-3.00$ /usr/local/bin/perl -v This is perldispatch. Id: $Id: perldispatch.c,v 1.17 2008/08/14 17:09:38 mschilli Exp $ Source: $Source: /CVSROOT/yahoo/tools/perldispatch/perldispatch.c,v $ Build: Aug 27 2009 14:35:42 perl58: /home/y/bin/perl5.8.6 perl510: /home/y/bin/perl5.10.1 -sh-3.00$ wt should i do so that it will take only 5.10 version?	[reply]
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]