Delete all records for all excel sheets

Help Studio
, , , ,
1

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.

Thanks

2

Hey @Hey_hi

Please find the reference - https://docs.uipath.com/activities/docs/clear-range-x

Thanks
#nK

1 Like
3

Hello @Hey_hi

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

1 Like
4

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 “”

5

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