Type of Spreadsheet
This specifies the type of spreadsheet. For vector spreadsheets, a combination
of variates, texts, and factors may be selected. They must be compatible; that
is, the same length and if more than one is restricted, the same units should
be included in each restriction.
Available Data
This lists data structures appropriate for the specified spreadsheet type.
You can double-click a name to copy it to the Data to Load box. Multiple
selections can be copied using the 
button.
Data to Load
This lists data structures that have been selected for the spreadsheet. For
spreadsheets of type Matrix or Table only a single data structure is allowed,
vector or scalar spreadsheets may contain more than one data structure.
Note: When a FSPREADSHEET directive is issued, it will
pick up any UNITS structure, if this is the same length at
the columns in a VECTOR spreadsheet. This column
will be added as a Units column in the spreadsheet (the first column after the
Row column, which is raised like the Row numbers). The Units column is fixed
to the left hand side, and is not lost from the screen when scrolling to the
right.
Load to Book
This provides a list of books that the new
spreadsheet can be added to. The default book that spreadsheets are added to
can be specified using the
Spreadsheet Options - Books menu.
See Also
File New - Spreadsheet
New Spreadsheet from Clipboard
Load Data From Files
Add Data to a Spreadsheet
Access Data from Excel
Excel Import Wizard
Using GenStat with Excel
Spreadsheet Options
Setting an Active Spreadsheet
FSPREADSHEET procedure
UNITS directive
Spreadsheet Add Data Menu