Add data from Genstat
You can append new columns to an existing spreadsheet by loading additional Genstat data structures. To add new columns select Spread | Add | Data in Genstat. Note that to add a column (data structure) it must contain the same number of rows as the structures within the current spreadsheet, otherwise it will be opened within a new spreadsheet.
Add data from a file
You can append new columns to an existing spreadsheet by loading additional data from a saved file. To add new columns select Spread | Add | Data file. Note that to add columns (data structure) from the file they must contain the same number of rows as the structures within the current spreadsheet in Genstat.
Calculate new columns
You can create new columns within an existing spreadsheet by calculating values from existing columns or other Genstat data structures. The new columns must have the same number of rows as the current spreadsheet. New columns can be calculated using the Calculate menu.
Create new rows and columns
You can extend the spreadsheet by inserting new rows or columns and typing in the data values. You can also use the Clipboard or the Column Fill menu to automatically generate data that contains patterns of values.
Getting columns from another spreadsheet
You can transfer columns between open spreadsheets using Spread | Column | Get/Move. To move columns between spreadsheets both must contain the same number of rows.
Add results from an analysis
You can append new columns to an existing spreadsheet by saving the results from an analysis. Data can be saved using the Save buttons on the Data or Stats menus and then displayed in a spreadsheet by selecting the Display as spreadsheet option. If the number of rows matches the spreadsheet containing the original, then you can use the Get/Move dialog to add the results to this spreadsheet.
Insert new rows or columns
Column Fill to automatically generate values.
Get/Move dialog for transferring data between spreadsheets
Using Genstat with Excel
Import Data from Excel
Import or export data
File New – Spreadsheet
New Spreadsheet from Clipboard
Supported data formats
The FSPREADSHEET procedure can add new columns into a spreadsheet within the command language.