wks.col.name$

name

Contents

1 Syntax
2 Type
3 Access
4 Description
5 Examples
6 See also

Syntax

wks.col.name$

Type

string

Access

Read/write

Description

Column short name

Examples

EX1

// Set col(1)'s short name in active sheet as "Time"
wks.col1.name$ = 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";

Ex2

This script loops over the all workbooks and columns, and then prints the names of the columns.

doc -e LB {
        loop (var, 1, wks.ncols)     
        {
                type "This is column %(wks.col$(var).name$) in %H, %(page.active$)";
        };
};

See also

wks.col.comment$, wks.col.lname$, wks.col.label$, wks.col.unit$