Excel operation on dynamic sheet name

[Md_Saiful_Khaleque]

I dowload 6 xlsx files each one having “CurrentAlarms*” type file names. Each having 1 sheet as “CurrentAlarms*”. Now i would like to perform delete rows, merge, lookup activities and generate a single xlsx file as outcome. Teied several ways but not working. Please suggest and help.

[MartianxSpace (Chitti)]

This might help.

How to get the sheet with dynamic sheet name

Hi Welcome to uipath forum Hope the below steps would help you resolve this this can handle one sheet or multiple sheet Use a excel application scope and pass the filepath as input From that scope itself we can get a output variable named out_workbook which is of type workbook Now use a FOR EACH activity where pass the above variable out_workbook.GetSheets as input And change the type argument as string In property panel Inside the loop use a READ CELL activity where mention the…

[supermanPunch (Arpan)]

@Md_Saiful_Khaleque

Teied several ways but not working.

Hi @Md_Saiful_Khaleque ,

Could you let us know what was not working ? What are the methods tried ? And what is your Expected Output ? If you could provide us Sample data and it’s Expected output in the form of excel files, we could help provide a Suggestion/solution better.

[Md_Saiful_Khaleque]

I succeed at last, Solved brother…I am stuck in another issue now…posting that soon. Pls help!

[supermanPunch (Arpan)]

@Md_Saiful_Khaleque ,

Great. You could post the Solution that you have used and mark it as the Solution and Close This Topic. This would help others who are also having similar issues.

[Md_Saiful_Khaleque]

I actually succeed in workbook get sheet name issue…but still strggling with the merging in right order and then lookup. Hence, I am waiting for the right time to share solution. Thanks for your concern dear.