excel-reader-xlsx icon indicating copy to clipboard operation
excel-reader-xlsx copied to clipboard

Published 20 hours ago • verified publisher icon jmcnamara

Too many files open

Open runrig opened this issue 13 years ago • 2 comments
trafficstars

I don't know if there's anything you can do about this, but in a spreadsheet with about 500 worksheets, I get: "IO Error too many files open". I know that each worksheet is in it's own file, but I don't know if the file handles are not getting closed as they get read, or if it's necessary to keep that many files open simultaneously, or if the bug is in some other library, etc. I have successfully run Archive::Zip ExtractTree on the file, and it all seems to get extracted ok. Will try to research further unless you beat me to it.

runrig avatar Aug 29 '12 18:08 runrig

Hi,

Sorry for not getting back to you on your other comments sooner.

Anyway, this sounds like a bug. I'll have a look at it.

P.S. This module is really at a rudimentary stage. I got bogged down in work for the last few months and didn't have a chance to push it beyond alpha code.

I hope to start working on it again in September.

Thanks for you input. Keep it coming.

John.

jmcnamara avatar Aug 29 '12 22:08 jmcnamara

Also note that my 'ulimit -n' is 256, and I was able to split up my workbook into workbooks of 200 sheets a piece, and processed those ok with no errors or warnings.

runrig avatar Aug 31 '12 00:08 runrig