You have to open Excel and check each sheet or at least one if it contains data - if it does you proceed with the TransferSpreadsheet, otherwise you stop.
I do not think there is another way. But you can limit the range so you do not check thousands if you know the data will be say in the first 500 columns and rows. It does not take long to run. I have done it, and it runs rather quickly.
I thought this would be the case. It seems a rather crude method. I think what I might end up doing is importing the file into a table and then checking how many records are in the table using:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.