Spreadsheet New Menu

To create a new spreadsheet select the New command from the Spread menu. You can then choose whether to open a spreadsheet loaded from GenStat data structures or the Clipboard, or a blank spreadsheet for typing in new data.

Create

This creates a blank spreadsheet which may be used for entering data from the keyboard. You can specify the type and size of the spreadsheet. New Vector spreadsheets are created with variate columns which can be converted to text or factor columns using the Column Attributes/Format command.

Data In GenStat

This loads data from GenStat into a new spreadsheet, using the Load Spreadsheet menu which allows you to define the spreadsheet type and specify the data structures to load into it. The data structures loaded will define the number of rows and columns in the spreadsheet.

From Clipboard

This loads data from the Clipboard into a new spreadsheet. If the first line contains only text values these will be used as the column names, otherwise default column names will be generated (C1,C2,...). Each row of data from the Clipboard will be loaded into a new row of the spreadsheet; values may be tab, comma, or space delimited, and blank rows on the Clipboard will create blank rows on the spreadsheet. The number of columns in the spreadsheet is defined by the row with the most values. Currently, only numeric data can be loaded in this way.

ODBC Data Query

Create a spreadsheet from an ODBC Data Source using the ODBC Data Query - Select Data menu which allows you to query an ODBC database.

DDE Link

This loads data from a DDE server into a new spreadsheet, using the Create Spreadsheet Using a DDE Link menu which allows you to specify the DDE data (Topic and Item) to load into it.

Excel Import Wizard

This loads data from an Excel file into a new spreadsheet, using the Excel import wizard which guides you through selecting the data from an Excel file in a step by step process.

Spreadsheets can be opened from other file formats using the File | Open menu item. The file formats supported can be found in Import or Export Data in Other Formats.

Book from Selected Sheets

This menu opens the Collect Sheets into a New Book menu, which provides a list of the open spreadsheets that can be collected into new book.

Append Multiple files

This opens the Append Multiple Files menu, that will take data from a list of files, and append them into a single spreadsheet, with a factor indexing which file each data row came from.

Append Multiple Excel Worksheets

This opens the Append Multiple Pages from an Excel file menu, that will take data from a list of worksheets from within a single Excel file, and append them into a single spreadsheet, with a factor indexing which worksheet each data row came from.

Merge Multiple files

This opens the Merge Multiple Files menu, that will take data from a list of files, and merge the columns from the various files into a single spreadsheet. The columns which indicate the matches between the rows from the various the spreadsheet need to be specified, and must have the same name in all the sheets.