Re: Need to generate excel having more than 70,000 records

[dragonchild]

in reply to Need to generate excel having more than 70,000 records

use Excel::Template;

my $template = Excel::Template->new(
    RENDERER => Excel::Template->RENDER_XML,
);

or Excel::Template->RENDER_BIG. Either way, E::T handles all that stuff for you.

[tilly]

I had not known about this module. Now that I know about it, it is clearly the right way to go.

[runrig]

I don't think that will work. Excel::Template says those options use Spreadsheet::WriteExcelXML or Spreadsheet::WriteExcel::Big as backends, and those modules still say they have a row limit of 65536. Spreadsheet::WriteExcel::Big lets you create files > 7MB, but still has the 65536 rows limit.

Update: The XML "template" of Excel::Template is a mini-DSL that the author uses to produce different kinds of files using the same code, and has nothing to do with the XML in Excel.