Get Sheet name in the case there is only 1 sheet

Hi, first of all, I have already read the topic How to get the Sheet name from Excel .

What I want to know is simple, even if I have only 1 sheet in my excel, should I use the IEnumerable type and For Each Loop?

I have a excel file with 1 sheet and I want to Read Range from it. It means I should set the sheet name in Read Range activity.

Thanks.

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

Best Regards…!!
Aksh

6 Likes

fantastic! I appreciate your help.

:slight_smile:

Is it possible to change the sheet name…without opening and closing excel