Delete all records for all excel sheets

Hi Everyone,

I would like to ask how can I delete all records from sheet 1,2,3 in an excel file without the use of invoke VBA.


Hey @Hey_hi

Please find the reference -


1 Like

Hello @Hey_hi

Why dont you delete the sheets and recreate again. You can use delete sheet activity to delete the sheets.

1 Like

First by using Get Workbook sheets(Get array of sheets)(Arr_Sheets)
Then …Take For each of sheets(Arr_Sheets)
Read Each Sheet(DT) inside for each
Then…Count = DT.Rows.Count
Now Take write cell (Range : A1: Destination Column+Count.Tostring)
Value as String.Empty or “”

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.