LabTalk Object Type:
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.
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. |