Wks.Col

Wks-Col-obj

wks.colObject, Column objects refer to columns in a worksheet or matrix objects in a matrix sheet. These objects contain properties that read or write column attributes such as names, units, types, etc. and methods that set the filter, formula, etc.

There are two syntaxes to refer to this object.

• wks.col -- active column (E.g. wks.col=2 set 2nd column to be active column. wks.col.lname$="Data" set 2nd column's long name.)
• wks.colN -- Nth column (E.g. wks.col2.lname$="Data" set 2nd column's long name.)

PropertiesColumn Property

MethodsColumn Method

Layer method

Examples

Edit Column Attributes

Set active column wks.col and then edit the attributes of it.

// Set the active column to 2.
wks.col = 1;

// Set the active column's(col2) long name as Time.
wks.col.LNAME$= "Time";

Alternatively, add index after wks.col to change the column attributes.

//Set column 1's long name as Time
wks.col1.LNAME$ = Time;

// You can reference another book, but the target sheet must still be active
// Set column 5 in the active sheet of Book5 to be an X column
Book5!wks.col5.type = 4;

// col0 to refer to last column
//set last column formula
wks.col0.formula$="A";

Set Custom Date Format

This script sets the format of column 2 of the active worksheet to a custom date format.

// Surround non-date characters in specifier by single quotes:
wks.col2.SetFormat(4, 22, yyyy'.'MM'.'dd);

Loop through columns and set column attributes

This script will loop through columns 2 to 10 and set each column long name.

// Set the number of columns to 10
wks.ncols=10;

for (i=2; i<=wks.ncols; i++)
{

   wks.col=i;  //set active column
   wks.col.lname$="Data$(i-1)";   //set active column's long name as

  //wks.col$(i).lname$="Data$(i-1) will also work
}