Read sheet with dynamic name

[Pranay_Kumar_Bose]

Hello All,
I am stuck in a problem where I need to read Data from an excel sheet. The excel file has few more sheets also. But the name of the sheet I want to read is “Unbilled May’23”. The problem here is the month and the year changes in the sheet name… like “Unbilled Jun’23” or “Unbilled Jul’23”.
How to read the sheet…
“Unbilled” word remains same.

[B_H_Akshatha_Pai]

Use for each excel sheet activity in UiPath

then read it

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Pranay_Kumar_Bose

Use For each excel sheet
If condition:CurrentSheet.Name.ToString.Contains(“Unbilled”)
Preform actions

[pravallikapaluri]

@Pranay_Kumar_Bose

“Unbilled May’23”.

Hi @Pranay_Kumar_Bose

CurrentSheet.Name=“Unbilled May’23"

Hope it helps!!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Pranay_Kumar_Bose ,
You can use for each sheet in Excel file, not need name, You can get by index
Regards,
LNV