in reply to Re: Write more than 1 million records into excel sheet
in thread Write more than 1 million records into excel sheet

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..
  • Comment on Re^2: Write more than 1 million records into excel sheet

Replies are listed 'Best First'.
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
    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.
      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?

        Either explicitly invoke perl5.10.0 or ask your system administrator.

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.