Get Active Sheet Name

[Lucas.Pimenta]

Hello!

Here’s some topics with the same question that you’re asking for:

How to get the Sheet name from Excel

Eduardo Bernabe Sacahui Diaz September 26, 2016 20:45 NONE Hello !!! Friends!!! I have so far two assigns and a for each and I am trying to get the sheet name or names of an specific workbook. thanks for the help. ====first assigng ==== myinfo = new Workbookinfo() this variable type is classexcelActivities.woorkbook also tried the interop.excel.workbook - ====second assing ==== ListofSheets = myinfo.getSheetList(mypath.tostring) this variable type is a list of strings - ====and …

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.

Hope It Helps!

Regards,