Do you know where your variables are? | |
PerlMonks |
Re: Need to generate excel having more than 70,000 recordsby whakka (Hermit) |
on Apr 02, 2009 at 02:56 UTC ( [id://754842]=note: print w/replies, xml ) | Need Help?? |
Excel is not the way to go for lots of data - no module will give you what you want since the limiting factor is built into Excel itself. I would follow the advice of Ish and output .csv which can be read in many types of software and inform your client what he/she wants isn't possible. Either that or split the data into multiple worksheets.
Here's Microsoft's outline of Excel's specification and limits. Update: It appears I should have read the fine print, sorry for the dated information.
In Section
Seekers of Perl Wisdom
|
|