Read 1st sheet of all the excels

[jamnanin (Naresh Jamnani)]

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?

[MAHESH1 (MAHESHKUMAR JV)]

@jamnanin
Try this in place of sheetname in Read Range Activity
Excelsheet1=xlwbook.Sheets.Item(1)

Regards,
Mahesh

[jamnanin (Naresh Jamnani)]

I am getting an error on this

[Dominic]

@jamnanin, Follow this links,

Get Sheet name in the case there is only 1 sheet

Hey @NatsuOK Yes you have to pass the sheet name in Read Range activity to read that sheet data. You can use the sheet directly by passing the index like "wb.GetSheets(0). where wb is [image] Best Regards…!! Aksh

Read range Excel sheet index

Hello there, Yes you can. Use excel application scope activity , create output variable from the property called workbook(eg:wb) To see the sheet name just use write line and pass like this wb.GetSheets(0). Then use Read range and in the sheet pass like this wb.GetSheets(0). PS: make sure to use that outside the excel scope(means you need to add one more excel scope and use read range there)

Regards,
Dominic

[jamnanin (Naresh Jamnani)]

@Dominic
thanks. got it