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

use Excel::Template;

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

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

My criteria for good software:

Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

Comment on Re: Need to generate excel having more than 70,000 records Select or Download Code

Replies are listed 'Best First'.
Re^2: Need to generate excel having more than 70,000 records by runrig (Abbot) on Apr 02, 2009 at 15:58 UTC
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.	[reply]
Re^2: Need to generate excel having more than 70,000 records by tilly (Archbishop) on Apr 02, 2009 at 15:07 UTC
I had not known about this module. Now that I know about it, it is clearly the right way to go.	[reply]