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 whakka (Hermit)
on Apr 02, 2009 at 02:56 UTC ( #754842=note: print w/ replies, xml ) Need Help??


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.


Comment on Re: Need to generate excel having more than 70,000 records
Re^2: Need to generate excel having more than 70,000 records
by tilly (Archbishop) on Apr 02, 2009 at 04:36 UTC
    Excel 2007 no longer has those limits. (Well it has limits, but they are much more generous ones.)
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 Mr. Muskrat (Abbot) on Apr 02, 2009 at 17:29 UTC

    The OP didn't specify which version of Excel would need to parse the file so I think that you have provided a perfectly acceptable answer.

      OP: "Since my client using latest windows excel he is expecting all the records having more than 70,000.".


      True laziness is hard work

        I see that in the OP but I still stand by my statement because "latest windows excel" can mean different things to different people.

        To Joe in IT it probably means "the latest version of Microsoft Excel for Windows".

        To Sally in payroll it might mean "the latest update" of whatever version of "Microsoft Excel for Windows" that she is running.

        And Bob in legal can have a different definition altogether...

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (11)
As of 2014-09-22 16:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

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











    Results (198 votes), past polls