How can I delete cell values in Excel

[maria.mitova (Maria)]

I have identical sheets, where I wan to delete the cell values, so that the report is clean and ready for the next month (see below).

Imagine row 5 and 6 were filled out and I want to delete them when I create the next monthly report.

[Palaniyappan (Forum Leader)]

@maria.mitova

want to delete them when I create the next monthly report.

Hi

We can simply use the write cell activity when you are filling for new month report
It will overwrite the value on it

It won’t require to delete if you are refilling the same cell with Write cell activity

Or if you are not writing again in same cell then try deleting with this custom component

BalaReva.Excel.Activities

Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to the clipboard 2.Delete Data activity - It deletes the data in the Excel Sheet 3.Clipboard To Datatable activity - It converts the clipboard to Datatable Namespace [image] 1.Properties Copy Data activity [image] Sample File : CopyData.zip (8.1 KB) 2.Properties of Delete Data activity [image] Sample : DeleteData.zip (6.9 KB) 3.…

Cheers @maria.mitova

[Rahul_S (Robot_L)]

Try with Delete Range

[maria.mitova (Maria)]

I am using StudioX

[Yoichi]

Hi,

Can you try Fill Range activity as the following?

Please set "" at What to write property using Advanced Editor.

Regards,