How to make below mentioned sheet name dynamic

dy_sht

Hi @mu_nazza

Have you tried with Get Workbook Sheets activity.

It will get all the sheet in List you can iterate with it

Regards
Gokul

Hi @mu_nazza ,

First you have to get the excel sheet name then pass the output variable to this activity.

@Gokul001


getting this error

@mu_nazza Pass it Like Excel.Sheet(sheet)
Where Excel is Reference of you Excel Scope and (sheet) is variable name of your Sheet.

Hi @mu_nazza

Use like the below expression

 Excel.Sheet(sheet)

Regards
Gokul