How to remove all the data from excel excluding headers only

Help
1

Hello,

I have one excel file with 5 columns having sample data. i need to delete the contents from excel file and just want headers with blank data in same excel.

Thanks,
Tushar.

2

@tmandhar I hope attached file you are looking for

ExlDelete.zip (9.2 KB)

3

The given workflow clears the datatable. but after deleting from datatable, i want data needs to be deleted from excel also.

4

Please try ‘Delete Data’ activity from “BalalReva.Excel.Actities”. It will delete data from excel.

5

There is no “Delete data” activity under balareva.excel.Activities
image

1 Like