Re: Spreadsheet::WriteExcel # of files limitation?

Do you call $workbook->close() when you finish each workbook?

Are you also closing your input files?

Most OS's limit how many files a process can have open at once, so if you're not closing the files, you're going to run out.

If you're doing all those things, then there could be a bug in SS::WE...
--
Mike

Comment on Re: Spreadsheet::WriteExcel # of files limitation?

Replies are listed 'Best First'.
Re: Re: Spreadsheet::WriteExcel # of files limitation? by tcdo6666 (Initiate) on Jul 16, 2002 at 17:47 UTC
Yea, i'm closing the input files as soon as i'm done reading from them and I'm closing the output files with $workbook->close() as well.	[reply]
Re: Re: Re: Spreadsheet::WriteExcel # of files limitation? by RMGir (Prior) on Jul 16, 2002 at 18:18 UTC
(Edit: Got rid of non-working code that tried to check lsof output) I guess this experiment didn't prove much... But looking at the code in the WriteExcel module, things seem to get closed when they should, so I'm puzzled... -- Mike	[reply]