Clean a sheet from excel file

[rchabbeh (rahma)]

hello,
i want to clean a sheet from an excel file and paste new data, the workflow below doesn’t work,
any help please?

[balupad14 (Balamurugan)]

Hi @rchabbeh,

Simply delete the sheet and Add a new sheet.

Delete sheet and add a new sheet activities available in here.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards
Balamurugan.S

[rchabbeh (rahma)]

I used delete range activity but nothing changes in the file!

[balupad14 (Balamurugan)]

No . Use the delete sheet activity…

Thank you
Balamurugan.S

[kommijeevan (Jeevan Kommi)]

Hi @rchabbeh

First delete filter data sheet. Use this package Balareva.Excel.Activities and use delete sheet
activity find this package in Manage package.
I have create workflow based on your requirement please run and check before run this
workflow please change the path where you save excel file path and then run I hope you will
get solution.

by using delete activity you can delete entire excel file not sheet. If you want to delete sheet alone use delete sheet activity.

First install this package (Balareva.Excel.Activities) in manage package and then you will get delete sheet activity.

FilterData.zip (32.9 KB)

Regards,
Kommi Jeevan.

[rchabbeh (rahma)]

thank you very much for this !
how can i clean the sheet without delete it ?

[AshwinS2 (Ashwin S)]

Hi @rchabbeh

Use assign activity and say it as Dt.CLear or clone

Thanks
Ashwin S

[RobertD (Docan Robert)]

You could try Delete Range with the range set to “A:XFD”.