Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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 drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2015-07-07 03:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls