Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

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

by dragonchild (Archbishop)
on Apr 02, 2009 at 12:33 UTC ( #754935=note: print w/ replies, xml ) Need Help??


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.

My criteria for good software:
  1. Does it work?
  2. 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
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.
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://754935]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2014-09-22 11:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (189 votes), past polls