Read first sheet regardless of name

[Gautham_Pattabiraman]

Hi @postwick ,

It is indeed missing in the modern version,Sheet index should be added to the read range activity.
But I found a workaround mentioned in our community forum, Hope it helps you.

Please check the thread below,

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)

Cheers.

Thanks,
Gautham