Delete 2 rows in Excel

hello I only want to delete row 1 and 2 in excel.

what is the expression in delete row activity ?


You can go for the insert/delete row activity.

Options you have to enter. No.of rows should be 2

Position should be 1 and method should be remove. Please try this option thus activity should be excel application scope


You can achieve it in couple of ways,

  1. By using ‘Delete Row’ activity as in the inline screenshot. ‘At Position’ property value is indicating to remove specified rows (ex: “1-2”)
  2. By specifying the Range property on the ‘Read Range’ activity as in the inline screenshot. A3 indicating 3rd row and Write the DataTable to another Excel file if needed.
    Delete 2rows 1

Hope this will help you. Thank you.