REMOVE
The REMOVE command is used to remove rows or columns from the Excel document.
The REMOVE command must be preceded by an OPEN command with write mode.
Required
REMOVE ----- OBJECT ----------- *ROW -------------------------->
*COLUMN
>-- RANGE ------------- n,n -------------------------->
Optional
>-- SHEET ------------ sheet1 ------------------------|
value
Keywords
|
OBJECT |
The type of object to be removed from the document *ROW, or *COLUMN. A value of *ROW is used to remove a single row or a range of rows from the specified sheet. A value of *COLUMN is used to remove a single column or a range of columns from the specified sheet. |
|
RANGE |
The range is either a single integer value or a comma separated pair of integer values. |
|
SHEET |
A specific sheet name can be entered otherwise the default value of sheet1 will be used. |