Hi everyone , My requirement is i have an excel with 4 sheets and i need to loop through sheets and delete all rows except headers currently i loop through each sheet , read range and use insert/delete rows activity inputs : noRows = dt.rows.count+1 position = 2 (bcoz need headers) sheetname b…

@kavya.s16 Check this attached workflow, Uipath_ClearDataExceptHeaders.zip (17.3 KB) Hope this may help you :slight_smile:

Delete rows in a datatable except headers (excel)

Topic		Replies	Views
Remove the Excel Rows Help	7	957	August 14, 2019
How to remove data from sheet without headers? Activities excel	18	1047	February 6, 2024
Delete excel data, less header Help datatable , studio	1	996	January 22, 2020
Excel leave only headers at first row and remove all other rows Studio excel , question	19	8728	May 30, 2022
Delete excel sheet data except header Help excel , activities , question	14	5982	January 25, 2020