Loading a Text File
Loading a tab-delimited file
Loading a text file that uses other delimiters
Overview
The fpSpread control and other software applications can save data into text files. Often, the data is saved to a tab-delimited file. Tab-delimited files contain data separated by tabs and carriage returns. Tab-delimited files can be opened, modified, and saved using any standard text editor.
If the text file does not use tabs as the delimiters, some software including the fpSpread control lets you specify other delimiters. When loading the file, be sure to indicate the same delimiters for cell, column, and row delimiters as the delimiters used in the file.
| Caution: Loading a text file into the control deletes the data currently in the control. The loaded file overwrites existing data. Also, if your sheet had more columns and rows than the loaded sheet, those columns and rows are removed. For example, if your sheet had 100 columns and rows of data, and the loaded sheet has 50 columns and rows of data, once the new sheet is loaded, the control only has 50 columns and rows. |
For information about saving Spread data in a text file, see Saving to a Text File.