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

Hi, I want to write more than 1 million records into one spreadsheet of excel sheet. I tried with Spreadsheet-WriteExcel , but it has a limit of 65536 rows. Will you please help me out? Thanks, Satyawan
  • Comment on Write more than 1 million records into excel sheet

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
      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..
        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.

        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.

Re: Write more than 1 million records into excel sheet
by Ratazong (Monsignor) on Dec 02, 2011 at 08:12 UTC