Spread Designer

To save a portion of the sheet to a delimited file

1. If you want to create a log file that records the manner in which Spread handles the save,
   1. From the Settings menu, choose General.
   2. In the General dialog,
      1. Select the Create a Log File when Importing/Exporting Files check box.
      2. Type the path and file name in the Create a Log File when Importing/Exporting Files box.
      3. Choose the OK button.
2. Select the block of cells you want to export to a delimited file.
3. From the File menu, choose Save As.
4. In the Save As dialog,
   1. Browse to the directory to which you want to save the file.
   2. From the Save as type drop-down list box, choose Custom File (*.TXT) or Comma delimited (*.CSV).
   3. 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.

   4. Choose the Save button.
5. If you are saving to a text file (*.txt), in the Custom Save/Open dialog,
   1. 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 ExportRangeToTextFile method.
   2. 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.
   3. 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.
   4. If you want to save only the data and not the formatting, select the Unformatted Data box.
   5. Choose the OK button.