Showing results for 
Search instead for 
Did you mean: 

MS Excel VBO get worksheet as collection: error on empty worksheet

Level 3


I have a question on how the 'MS Excel VBO::Get Worksheet As Collection' action, as I am currently using it in a loop, reading all worksheets of a set of input xlsx files, yet, when it arrives on the second worksheet of a file, which is empty, it gives me the error "ERROR: Internal : Could not execute code stage because exception thrown by code stage: Object reference not set to an instance of an object.". 

What I don't understand is that it shouldn't be not set to an instance of an object, since the worksheet does exist, though it holds no values inside, shouldn't it still be treated as an empty worksheet and simply return an empty collection ?


Thanks in advance for your returns,