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 > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
