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


Pathologically Eclectic Rubbish Lister
	PerlMonks

by dragonchild (Archbishop)

on Apr 02, 2009 at 12:33 UTC ( #754935=note: print w/replies, xml )

Need Help??

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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://754935]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (2)

As of 2023-04-02 01:51 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found

Notices^?