REMOVE
From LANSA Integrator
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. |