To get Excel Sheet Name

[madhavraichur25]

Hi Ui path Community
i need to generate excel automation but the problem is the the sheet name keeps on changing after every download is there any way i can get sheet name from excel and store in a variable so that i can use it later
Attached the above screen shot for reference

Thank you in Advance

[AutomationX_by_Kiran]

Hi @madhavraichur25 ,

This below link will help u

How to get Excel Sheet name?

Hi, I face a scenario where I am reading an excel file which has sheet name as “Sheet2” . But this Sheet name could change going forward. So, While reading a file using “Read Range” activity, How to pass the “Sheetname” which is currently available in the file rather than hardcoding it? Thanks in Advance

[Yoichi]

Hi,

FYI, another approach:
If the xlsx file has just single sheet, the following will work.

Regards,

[ashokkarale]

@madhavraichur25,

You can use classic activity Get Workbook Sheets for this.

Activities - Get Workbook Sheets