http://www.perlmonks.org?node_id=754842


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
    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 Mr. Muskrat (Canon) 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...