Delete cells in an Excel using Workbook or datatable

[abdel (Robot usa)]

Hello,

I’m trying to delete Excel file data using write celle ( Workbook: string.empty),:

but it take much more time, and need a delay of 10 second between two Excel manipulation.

Ca we do the using datatable ?

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @abdel
In DataTable You can remove entire row and replace a single cell with null

[RajKumar_DC (RajKumar Durai)]

Hi @abdel,

can you plz explain more with example ?

Thanks,
RajKumar Durai

[abdel (Robot usa)]

Hi @RajKumar_DC,

I had attached a sample of the xlsx file: lines Number may be more or less.

Actually I’m using write cell (workbook activity) to delete the content of cells inside this file:
a write cell (empty string) inside a while loop with a counter:

I want to use datarable, exemple: read the file, loop throught the generated datatable and delete the celles
sample.xlsx (34.1 KB)