Delete 2 rows in Excel

Help Studio
, ,
1

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

what is the expression in delete row activity ?

2

Hi,

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

3

@Nightowl_music

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

Delete 2rows 2
Delete 2rows 2631×590 14.3 KB

Hope this will help you. Thank you.