Saving data from a spreadsheet

Saving data to a GenStat Book (GWB) file

Spreadsheets in multi-paged books can be saved using the GenStat Book (GWB) file format. This is GenStat's own file format that saves all the spreadsheets within the book and preserves all the column attribute information such as type, widths, decimal places etc... for each spreadsheet contained within book. An advantage of using this format is that all information is restored when you next open the file, whereas saving in other file formats can result in the loss of some information.

Saving data as a GenStat Spreadsheet (GSH) file

Individual spreadsheets (single pages in a book) can be saved using the GenStat Spreadsheet (GSH) file format. This is GenStat's own file format that stores all the data and associated information. The advantage of using this file format is that you can easily reproduce exactly the same spreadsheet the next time you open the file. Saving in other formats can result in the loss of some information.

Saving data in foreign file formats

The Save As item on the File section of the menu bar allows you to save the data in a foreign file formats. GenStat supports a wide range of foreign data file formats such as Excel, Quattro etc... You can also save a spreadsheet as a plain text file or CSV file, which is a form for the data that is accepted by most applications.

Saving data to an Excel file

One of the most commonly used spreadsheet applications is Microsoft Excel. In GenStat you can save data from a spreadsheet to an Excel file using any of the following Excel versions: 2, 3/4, 5/95 or 97/2000/XP. You can save one or more spreadsheets in a multi-paged book in GenStat to Excel where each spreadsheet is saved to a separate worksheet in Excel. By default, if you save to an Excel file that exists GenStat will prompt you with a choice of overwriting the file or adding new worksheets to the Excel file. Spreadsheets can also be added to an Excel file using the the Add to Excel file item on the Sheet submenu of the Spread menu.

Saving a selection from a spreadsheet

A selection of cells, rows or columns can be saved to a GenStat Spreadsheet (GSH) or Book (GWB) file, or to another foreign file format. To save a selection you can use the Save Selection item from the File section of the menu bar.

Saving data to a GenStat Command file

One or more spreadsheets within a book can be saved as a GenStat command file. A GenStat command file is a plain text file containing code formed using the GenStat command language. When a spreadsheet or book is saved in this format the data along with the GenStat commands required to construct the GenStat data structures for the data are written to the file using. Data saved in this format can be opened as a plain text file and run as a GenStat program using the Run menu. Alternatively, if you are writing GenStat programs you could incorporate these GenStat commands within your program using the OPEN and INPUT directives.