Choosing to import into the Data Worksheet a spreadsheet, database, or HTML file from the File Import Dialog brings up a window similar to the one for Excel spreadsheets below. Multiple worksheets or tables within the larger spreadsheet workbook or database are available through a pull-down listbox. The contents of the spreadsheet or data table are displayed in the large preview area. When the OK button is pressed the contents of the file are read into the GS+ Worksheet according to rules specified by the Properties command. A similar dialog window is available for importing text files.
When importing spreadsheets, the first row of the imported spreadsheet should hold the variate names that appear in the GS+ column headings (“Day” in column 1, below). If the first row of the spreadsheet contains values, they will be ignored.
The worksheets or tables within individual spreadsheet or database files are listed here and can be chosen via the pull-down listing.
The Properties Command brings up a File Import Properties dialog window within which you can specify how GS+ should identify missing values. When importing spreadsheets and databases, other file import properties are limited to single pre-defined choices – e.g. spreadsheet columns are used to denote different GS+ Worksheet fields.
The Change command brings up a Field or Column Assignment window from which you can assign variates (e.g. X coordinate) to columns or fields in the data file. Columns can be reassigned later from the Data Worksheet window.
_import_dialog.gif)
Press OK to import the specified filedata into the GS+ Worksheet and close the dialog window. If data already exists in the GS+ Worksheet, you will be asked what to do with it.
Press Cancel to exit the dialog without importing data.