This menu can be used when reading a CSV file into a spreadsheet
to just read part of the CSV file, for example using just a subset
of the data lines, or to skip the heading and footnote text in a CSV
file. Other cases these options may be useful for include CSV files that
contain multiple data sections with tags to indicate the start and end
of a data section, or those in which the column names do not immediately
precede the data.
Limit Lines to be read
This option must be selected to use the following options to read just part
of the CSV file. The options are kept from the previous usages of this menu,
so that turning this off allows previous settings to be retained, but not
used for this particular CSV file.
Start of first line
This specifies a text string that specifies the first line. This may be a tag
which indicates the start of the data section, or the first column name.
Exclude first line
If the first line is a tag and not part of the data, or the row of column names
then you will want to select this item to exclude in from being read as part
of the spreadsheet data.
End of data marker
This specifies a text string that specifies the line following the last data
line. The line starting with this text will not be read as part of the data,
and the previous line will be the last line in the data.
First line number to read
This specifies the first line to start reading the file from. If the Start
of first line string is set, it will be looked for after this line, otherwise
this line will be the first line read as either column names or data.
Number of data lines to read
This sets the maximum number of data lines to be read in. This can be used
to read in just a subset of the data lines.
Column names in Line number
By default, if column names are being read in, they will be taken as the first
line of the file read (which will depend on the settings of Start of first line or
First line number to read settings. Setting this option allows the column
names to be read from any line within the CSV file.
OK
Read the CSV file into a spreadsheet using the specified options.
Cancel
Close the dialog without reading in the CSV file into a spreadsheet.
See Also
New Spreadsheet from Clipboard
Load Data From Files
File New - Spreadsheet
Spreadsheet New Menu
Spreadsheet Add Data Menu