Spread Designer
To save to a delimited file
- If you want to create a log file that records the manner in which Spread handles the save,
- From the File menu, choose Save As.
-
In the Save As dialog,
- Browse to the path and directory to which you want to save the file.
- From the Save as type drop-down list box, choose Custom File (*.TXT) or Comma delimited (*.CSV).
-
Type the file name in the File name box.
If you would prefer to use a different file extension, type it along with the file name in the File name box.
Note: If you use a different file name extension, the file will still be saved as the file type chosen in the Save as type drop-down list box. - Choose the Save button.
-
If you are saving to a text file (*.txt), in the Custom Save/Open dialog,
-
Specify the characters for each delimiter in the boxes.
If you want to use special characters as the delimiters or as part of a delimiter string, select the special character to use in the Special Characters list, then choose the appropriate button to add the special character as a delimiter. For more information about working with delimiters in text files, see the ExportToTextFile method.
- If you want to save the numbering or data in the column or row headers to the text file, select either or both of the Column Headers and Row Headers boxes.
- If you want to append this data to an existing file (which is the file you specified in the File name box), select the Append to File box.
- If you want to save only the data and not the formatting, select the Unformatted Data box.
- Choose the OK button.
-
Specify the characters for each delimiter in the boxes.