in reply to Need to generate excel having more than 70,000 records
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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Need to generate excel having more than 70,000 records
by ELISHEVA (Prior) on Apr 02, 2009 at 08:28 UTC | |
Re^2: Need to generate excel having more than 70,000 records
by tilly (Archbishop) on Apr 02, 2009 at 04:36 UTC | |
Re^2: Need to generate excel having more than 70,000 records
by Mr. Muskrat (Canon) on Apr 02, 2009 at 17:29 UTC | |
by GrandFather (Saint) on Apr 02, 2009 at 21:50 UTC | |
by Mr. Muskrat (Canon) on Apr 13, 2009 at 18:32 UTC |
In Section
Seekers of Perl Wisdom