REMOVE

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.