How to remove all the data from excel excluding headers only


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.


@tmandhar I hope attached file you are looking for (9.2 KB)

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

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

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

1 Like