How to fetch excel sheet name on every download of excel file?

Hi All,

I have to get the sheet name of each excel file whenever its download.
So I have used for each activity and inside the loop added excel scope and Get workbook sheets.

But when i execute , it’s not entering into For Each activity. It is just exiting the loop and stopping the execution.

Any help would be appreciated:-)

1 Like

Hi,

Can you put a message box and display the count in files before proceeding to for each? if it doesnt go inside , it means files is empty

Please check the download location if files are available & var path should contains only the folder path.

Hello @Vaishnav_Tej
Kindly Refer to this thread, you may get some idea

HI @Vaishnav_Tej

You can check the count as @vishnuvarthanp said

Can you share the full expression in the Files assign Directory.GetFiles…?

REgards
Sudharsan

1 Like