How to Clear Data in Excel A to H columns

Help Studio
, ,
1

Hi,
i have excel file in that A to J columns there .
in the A To H columns data i dont know how many rows will come.
i want to delete the A to H columns data.

image

can any one help ?

clearData.xlsx (11.9 KB)

2

Hi @Anand_Designer

Using delete range we can achieve that!

Regards

3

Hi,

You can also try Insert/Delete Columns:

The benefit of this activity is that you don’t need to specify how many rows you want to delete. You can delete the entire columns specified, which should be more suitable in your case.

4

Hi @Anand_Designer
try this
it removes the column data
Inside a for each datatable activity
If(Currentrow(“Name8”).ToString)).contains(“”)
else
{
Currentrow(“Name8”)=“”
.
.
.
Currentrow(“Name1”)=“”
}