Remove

Remove activity is used for deleting the inside of a column or a cell in an Excel file.


* Excel name	The reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet name	The name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet index	Index of the sheet to work in Excel. If not added, it takes the first sheet by default.
Rows	The row index is written.
Column	Column name or index is written. If it is wanted to delete more than one column, it is named a column number, column letter, or column heading by separating it with a comma.

Note: * Fields selected with are required, others are optional.

Excel name example

You can use the Excel name as shown in the example.

newExcel

Sheet name example

You can use the Sheet name as shown in the example.

Sheet1

Sheet index example

You can use the Sheet index as shown in the example.

5

Rows example

You can use the Rows as shown in the example.

1

To select multiple rows, use “:”

1:5

Column example

You can use the Column as shown in the example .

1

A

A, B

Note

Sheet name field can be left blank if it is desired to operate on the first page of the Excel file. Otherwise, it has to be filled.

In Excel, rows begin with 1, columns begin with 0.

If you want to delete only a row in Excel, the column is left blank.

If you want to delete only a column in Excel, the row is left blank.