4 - 26 Text Spreadsheet Loader
The Text Spreadsheet Loader add-on allows you import simple data from ASCII files. Select the delimiter and I-skip (if necessary) from the Simple Spreadsheet File Loader dialog.
the Text Spreadsheet Loader dialog has the following options:
• Filename - Enter the path to the file you would like to load.
• Delimiter - Choose whether your data is separated by a comma, space, or tab.
• I-Skip - Select an I-skip value. A value of 1 loads all values, a value of 2 loads every other value, and so on.
The Text Spreadsheet Loader can read ASCII files of the following format (blank lines are ignored):
|
Variable 1, Variable 2, ..., Variable N |
|
datapoint1,datapoint2, ..., datapoint N |
|
. |
|
. |
|
. |
|
datapoint1,datapoint2, ..., datapointN |
Here is an example of a valid ASCII spreadsheet file:
|
Month, Rainfall |
|
1, 15.0 |
|
2, 21.0 |
|
3, 21.0 |
|
4, 32.0 |
|
5, 10.3 |
|
6, 5.1 |
|
7, 2.3 |
|
8, 0.2 |
|
9, 1.4 |
|
10, 8.3 |
|
11, 12.2 |
|
12, 15.4 |
|
The first line must contain all of the variable names.See Creating Plots. |