Delete multiple excel sheets from timestamp workbook

[Anand_M (Anand Kumar)]

Dear all,

I need a solution to delete multiple sheets from a single workbook which it creates on runtime with a timestamp. (e.g. “COVID-19-Pandemic Data-25-05-2020-10.56.11.xlsx”)

I wanted to delete the repeated sheets and keep only (COVID19_Final_Report) from excel workbook, Can you please provide me the solution.

Thanks in advance!

Anand Kumar

[ImPratham45 (Prathamesh Patil)]

Refer below Workflow
You will get idea
Test.xlsx (7.8 KB) Main.xaml (18.1 KB)

[Anand_M (Anand Kumar)]

Hello @ImPratham45,

I tried to run your xaml file, I am getting Invoke VBA: File not found.

Thanks
Anand Kumar

[ImPratham45 (Prathamesh Patil)]

sorry i havent send you
SheetToDel.txt (102 Bytes)

[Anand_M (Anand Kumar)]

Hi @ImPratham45,

Thank you, It’s working fine now, but I am looking for a solution that excel file tabs need to be deletedWorldometer.xaml (52.3 KB) automatically without popup message. I hope you understand my requirement, I have attached my XAML file can you run and check the output of excel file.

Regards
Anand

[balupad14 (Balamurugan)]

hi @Anand_M,

Here is the activity with sample…

Delete Sheet

Hi @Babita22, Welcome to UiPath Community Forum ! Here I have attached the sample to delete the sheet … Before Delete : [image] After Delete : [image] Design Screen: [image] Sample : Babita22.zip (30.5 KB) Package info : Regards Balamurugan.S

Regards
Balamurugan.S

[Anand_M (Anand Kumar)]

Hello @balupad14,

Thank you, I already tried this solution, the problem is since my excel is creating on runtime with the timestamp, I am getting error like this (e.g. “COVID-19-Pandemic Data-25-05-2020-10.56.11.xlsx”) is not found or moved or deleted.

Regards,
Anand

[ImPratham45 (Prathamesh Patil)]

I will send it tomorrow

[balupad14 (Balamurugan)]

Can you send me your sample workflow ?

Regards
Balamurugan.S

[Anand_M (Anand Kumar)]

Hello @balupad14, Please find attached workflow, Let me know if need any further information.

Thanks
Anand Kumar

Worldometer.xaml (52.3 KB)

[Anand_M (Anand Kumar)]

Sure, no problem, Thanks again for your support and quick response.

Thanks
Anand Kumar

[ImPratham45 (Prathamesh Patil)]

Replace older text file with this one
SheetToDel.txt (171 Bytes)

[Anand_M (Anand Kumar)]

Hi @ImPratham45,

Thanks for the solution, Now my workflow is working as expected. Thanks a lot for your support.

Regards
Anand

[ImPratham45 (Prathamesh Patil)]

Your Most welcome!

Happy Automation