Open Scrollsheet statement

 [/h/]Opsc
   [/h/]iFile[=file_name]
   [[/h/]Optn[=Nam-Cmt-Auto]]
   [[/h/]Fmat[=Norm|Fit|Max|Min|Merge|AddTser]]
   [[/h/]Ttol[=time_tolerance]]
   [[/h/]Fixc[=number_of_columns]]

Type conventions and statement syntax are explained in the Glossary.

Parameters...

iFile
File parameter indicating the scrollsheet file to be loaded. Must be specified, there is no default. You may specify Wintrack scrollsheet files (.WTB), tab-delimited text files (.TXT), comma-delimited text files (.CSV), and space-delimited text files with fixed column width (.LOG).

Optn
Check box parameter indicating execution options. Default = None, else any combination of the following options:

• Nam = import column names from the first row of data,
• Cmt = import column comments from the second row of data,
• Auto = use numbers in first data row as a template for formatting numeric columns.

Fmat
Radio button parameter indicating the size of the new window or specifying how to merge data.
Default = Norm, else any of the following options:

• Norm = default size assigned by Windows™,
• Fit = automatic fit of data to be shown,
• Max = maximize window,
• Min = minimize as icon.
  

The following two options instruct Wintrack to open the source scrollsheet, merge its data with a target scrollsheet and to close the source as soon as the data are merged. The target scrollsheet is the one displayed in the topmost scrollsheet window as the command is invoked. Columns of the source scrollsheet are transferred to the target scrollsheet creating new columns there as needed:

• AddTser = transfer of data from the source to the target is controlled by time stamp or time stamp and date, expected in the first columns of both scrollsheets. For each time stamp / date in the target scrollsheet, Wintrack looks for a matching row in the source scrollsheet. If one is found, its data are transferred to the target scrollsheet. The maximal allowed time difference between matching time stamps is specified using the Ttol parameter. This option works only with sampling intervals of 1s or longer. No new rows are added to the target scrollsheet.
• Merge = transfer of data from the source to the target is controlled by case names which are expected in the first column of both scrollsheets. From each row of the source scrollsheet, data are transferred to the row in the target scrollsheet that has the same name. If no such row is found, a new one is appended to the target scrollsheet.

Fixc
Number parameter indicating the number of non scrolling columns at left edge of the scrollsheet. Default = 0.

Ttol
Number parameter indicating the maximal allowed time difference between matching time stamps. Only relevant if Fmat=AddTser.

Note that...

The Optn and Fixc parameters are only considered if the source file is not a Wintrack scrollsheet (.WTB) file. When encountering a text file, Wintrack determines the column/field delimiter as follows. If the file contains any tab-characters, tab is used as delimiter. Else, the file is scanned for commata. If any are found, comma is used as delimiter. If a file contains neither tabs nor commata, it is assumed to be space-delimited with fixed column width. Tab-delimited text is the preferred format for data import from other applications. In this format cell data may contain spaces and/or commata. Space-delimited files may not be imported correctly if they contain empty cells.

Additional information...

• See the topic Open Scrollsheet command for basic information on the command.
• Inside scrollsheets provides advanced information on scrollsheets.
• See Creating and using macros to learn how to use and create macros.
• There are lists of all available macro statements and menu commands.