ColumnListUpdate
The
ColumnListUpdate verb reorders
the columns in a data source.
The equivalent operation on the user interface is to drag and drop the columns as required.
The syntax is as follows:
ColumnListUpdate [DataSource objDataSource] StartList
objCols EndList| Argument |
Description |
|---|---|
| DataSource objDataSource |
Specifies the data source to be reordered. objDataSource can be the data source object name, object identifier, or both. |
| StartList objCols |
Lists the columns in the desired order. If not all columns are listed, the listed ones move to the top of the list. The columns can be identified by object name or object identifier. |
Example
This example reorders the columns in the Excel data source "All Staff Count" so that Branch Code is first, followed by Time and Staff Count.
ColumnListUpdate DataSource "All Staff Count (Excel)" StartList "Branch Code"
"Time" "Staff Count" EndList