i'm wondering if is there a way to disconnect single worksheet while walking file content to save memory.
I mean, if i have to parse several excel files, every file parsing can be closed by a simple
that disonnects worksheets from the object and unsets the object. This allows the script to run on many files without using Terabytes of memory :)
my problem is if INSIDE a single file i've ENORMOUS worksheet. In this case, as you can understand, disconnecting worksheets at the end of parsing is a nonsense, but as far as i know there is not a way to disconnect a SINGLE worksheet while parsing a file
am i wrong?