i want to clean a sheet from an excel file and paste new data, the workflow below doesn’t work,
any help please?
Simply delete the sheet and Add a new sheet.
Delete sheet and add a new sheet activities available in here.
I used delete range activity but nothing changes in the file!
No . Use the delete sheet activity…
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
by using delete activity you can delete entire excel file not sheet. If you want to delete sheet alone use delete sheet activity.
FilterData.zip (32.9 KB)
thank you very much for this !
how can i clean the sheet without delete it ?
Use assign activity and say it as Dt.CLear or clone
You could try Delete Range with the range set to “A:XFD”.