Get Sheet name in the case there is only 1 sheet


#1

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.


Get Active Sheet Name
Reading xlsx file
How to read the different sheet names in excel
#2

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


Read 1st sheet of all the excels
#3

fantastic! I appreciate your help.


#4

:slight_smile:


#5

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


#6