Save Spreadsheet as a Text File

To save the contents of a spreadsheet as an ASCII text file select Save As from the File menu, then choose the File Type as Text File (*.txt). The Options button allows you to control how the text file is written (see below).

Maximum Character Width

This sets the maximum number of characters that can be written to any line of the file. Any row of the spreadsheet that requires more characters than specified will be wrapped, to form multiple lines in the text file. You may need to set the maximum width if you wish to read the data into other programs or output to the printer. In particular, reading data in GenStat using commands assumes a width of 80 characters unless specified otherwise in the OPEN statement.

Comment Line

If selected, this will add a GenStat-style comment, enclosed in double-quotes (") at the start of the file.

Variable Names

If selected, this will include a row indicating the names of each column.

Quoted Text

If selected, this will enclose strings in single-quotes (').

Comma Delimited

If selected, values will be separated by commas. Otherwise values will be separated by spaces.

Terminating Colon

If selected, a colon (:) will be written at the end of the file.

Separate Data Columns Using

Specifies how to separate the columns of data within the file. You can use either a space, tab, or comma.

Notes

To produce an ASCII data file suitable for loading via the Load ASCII File menu a suitable combination of options is: Comment Line, Variable Names, Quoted Text, Maximum Width 200.