By the way, my file size around 22 MB so, is it possible that Spreadsheet::WriteExcel::Big is not good enough for this size?
--- 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/
