> -----Original Message----- > From: a_arya2000 [mailto:[EMAIL PROTECTED] > Sent: Monday, July 16, 2007 14:06 > To: [email protected] > 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/
