Loading an excel file from second cell onwards


#1

Can we check before loading if an excel file's first row is empty or not?

I want to be able to track that and re-insert a new row just below it to replace the contents of first row and make first row empty (if it is not already empty).

Can we do something like that?

The whole purpose is to make first row empty so that I can insert my own dropdownlist box with a default value in it.

Thanks,
-Soven


#2

I figured it out. Its one of the example in pivotTable.

Can I combine all worksheets of an excel file and display it under one main tab?

And can tabs be hidden programmatically? (Not on evaluation version).