I have like around 24K rows. Thank you. Arya --- "Wagner, David --- Senior Programmer Analyst --- WGO" <[EMAIL PROTECTED]> wrote:
> > -----Original Message----- > > From: a_arya2000 [mailto:[EMAIL PROTECTED] > > Sent: Monday, July 16, 2007 14:06 > > To: beginners@perl.org > > Cc: a_arya2000 > > Subject: Re: Spreadsheet::WriteExcel problem with > large file > > > > By the way, my file size around 22 MB so, is it > > possible that Spreadsheet::WriteExcel::Big is not > good > > enough for this size? > how many rows are you talking about? If over 65k, > then need to > make multiple worksheets as you can not go over 65k > rows per worksheet. > > Wags ;) > David R Wagner > Senior Programmer Analyst > FedEx Freight > 1.408.323.4225x2224 TEL > 1.408.323.4449 FAX > http://fedex.com/us > > > > > --- a_arya2000 <[EMAIL PROTECTED]> wrote: > > > > > Thank you very much for suggestions guys, I > tried > > > using Spreadsheet::WriteExcel::Big but still > having > > > the same issue. I am not sure, what I am doing > > > wrong. > > > My file size is indeed more than 7 MB. > > > Thank you, > > > Partha Dhar > > > > > > --- Raja Vadlamudi <[EMAIL PROTECTED]> > wrote: > > > > > > > Use Spreadsheet::Big module if the file size > > > happens > > > > to be larger than 7 MB. > > > > The latest Spreadsheet module will have this > Big > > > > module integrated, but if > > > > you are using older version, then you need to > use > > > > this Big module. > > > > > > > > > > > > On 7/16/07 8:46 AM, "Rob Dixon" > > > <[EMAIL PROTECTED]> > > > > wrote: > > > > > > > > > a_arya2000 wrote: > > > > >> > > > > >> Hi, the problem is, when write large > > > spreadsheets > > > > of 20,000 rows or > > > > >> so, the module finishes without error, but > when > > > I > > > > try to open the > > > > >> spreadsheet with Excel I get error messages > > > about > > > > the spreadsheet > > > > >> being 'unrecoverably scrambled'. I've never > had > > > a > > > > problem with it > > > > >> except for these very large spreadsheets. > It > > > > works great on smaller > > > > >> ones. > > > > >> > > > > >> Is there any work around for this? Or Is > there > > > > any other module that > > > > >> will do that work? > > > > > > > > > > Try calling the 'close' method on your > workbook, > > > > and see the module's > > > > > documentation on this - particularly with > regard > > > > to garbage collection. > > > > > > > > > > $workbook->close; > > > > > > > > > > HTH, > > > > > > > > > > Rob > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________ > > ______________________ > > > Get the Yahoo! toolbar and be alerted to new > email > > > wherever you're surfing. > > > > > > http://new.toolbar.yahoo.com/toolbar/features/mail/index.php > > > > > > -- > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > http://learn.perl.org/ > > > > > > > > > > > > > > > > > > > > ______________________________________________________________ > > ______________________ > > Get the Yahoo! toolbar and be alerted to new email > wherever > > you're surfing. > > > http://new.toolbar.yahoo.com/toolbar/features/mail/index.php > > > > -- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > http://learn.perl.org/ > > > > > > > > ********************************************************************** > This message contains information that is > confidential and proprietary to FedEx Freight or its > affiliates. It is intended only for the recipient > named and for the express purpose(s) described > therein. Any other use is prohibited. > ********************************************************************** > > > -- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > http://learn.perl.org/ > > > ____________________________________________________________________________________Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
