System.Wks

LabTalk Object Type:

Utility

The wks object is a sub-object of the system object. The wks object properties allow you to read and alter worksheet-related settings which are set in the OPTION.CNF file. These settings can also be accessed in the Options dialog box.

 

Properties:

Property Access Description
system.wks.autoDelCol Read/write,
numeric

Automatically delete datasets from a worksheet when closing the worksheet. 1 = enable, 0 = disable (display a prompt).

system.wks.closeExlPrt Read/write,
numeric

Display a prompt when closing an Excel workbook window: 0 = hide only, 1 = display prompt, 2 = delete without prompt.

system.wks.closeMatPrt Read/write,
numeric

Display a prompt when closing a matrix window: 0 = hide only, 1 = display prompt, 2 = delete without prompt.

system.wks.closePrompt Read/write,
numeric

Display a prompt when closing a worksheet window: 0 = hide only, 1 = display prompt, 2 = delete without prompt.

system.wks.defTemplate Read/write,
string

The default template to new a workbook. The default value is ORIGIN, which means the built-in workbook template origin.otwu. Need specify the file path and file name both for other template files.

system.wks.numericData Read/write,
numeric

Set all columns in all new worksheets to Text & Numeric (default) or to Numeric: 1 = Numeric, 0 = Text & Numeric.

system.wks.transpDelEmptyCols Read/write,
numeric

Controls whether columns are deleted after transposing the worksheet. 0 = always delete columns, 1 = never delete columns, 2 = prompt for delete.