I am trying to read only the 1st sheet of all the excel files in a directory. But the problem is while using read range I have to specify the sheet name but the sheet names are different for all the excel files. How can I ask it to read only the 1st sheet irrespective of the name in the for each loop?
Try this in place of sheetname in Read Range Activity
@jamnanin, Follow this links,
thanks. got it