Wks.Export
Wks-Export-obj
LabTalk Object Type:
- Window Object
The export object is a sub-object of the wks object.
|
Please see the expAsc X-Function.
|
Properties:
The export object is accessed using the following syntax:
[winName!]wks.export.property =
WinName! is optional. If winName! is not specified, the active worksheet is affected.
Property |
Access |
Description |
wks.export.c1 |
Read/write
numeric |
First column in the data range to be included with the data file. Set to 1, 2, ... n. To include all data, set to 1 (default).
|
wks.export.c2 |
Read/write
numeric |
Last column in the data range to be included with the data file. Set to 2, 3, ... n. To include all data, set to 0 (default).
|
wks.export.cntrl |
Read/write
numeric |
Include or exclude column names and labels with the data file and export a range of data. The value of this property controls export of Column Names, All Data, and Column Labels as follows:
Bit Values* |
Column Names |
All Data |
Column Labels |
1 |
YES |
NO |
NO |
2 |
NO |
YES |
NO |
4 |
NO |
NO |
YES |
8 |
export selected data |
Note that bit values are additive. For example, to export Column Names + All Data + Column Labels, set the value to 1 + 2 + 4 = 7.
|
wks.export.r1 |
Read/write
numeric |
First row in the data range to be included with the data file. Set to 1, 2, ... n. To include all data, set to 1 (default).
|
wks.export.r2 |
Read/write
numeric |
Last row in the data range to be included with the data file. Set to 2, 3, ... n. To include all data, set to 0 (default).
|
wks.export.separator$ |
Read/write
numeric |
Specify the separator for use in the data file. The default separator is "\t". The syntax is as follows: wks.export.separator$ = "," for a comma separator.
|
- The range selected by the C1, C2, R1, and R2 properties will be used as long as there is no selection or only a single cell selected in the worksheet. If any other selection is active in the worksheet, that selection will be used.
- If exported, column names are copied to the first line of the data file with the designated separator, followed by <CR>, then the labels (if exported), then the data.
Examples:
This script specifies the column range, row range, and separator for data export. It also specifies that the column names be exported with the file.
<pre> wks.export.c1 = 2;
wks.export.c2 = 4;
wks.export.r1 = 2;
wks.export.r2 = 12;
wks.export.cntrl = 1;
wks.export.separator$ = ",";
getfile *.dat; // get a file name to use
save -wh %H %A; // export the active window (must be wks)
</pre>
|