open2.png Import Data Source


Use the Import Data Source option to add a disk-based file containing one or more XYZ data sets to the current notebook. This option is available from the main File menu, in the main toolbar, and when right clicking the uppermost or notebook item in the TableCurve Studio Explorer.

This option only adds the data file to the notebook making it available as a source for XYZ data.

To import data from the clipboard in a tabular format, you must use the Import Special Import Clipboard option. For data in a matrix format, use the Import Clipboard Matrix option. These options create a file that is automatically added to the notebook.

Explorer Content

tree1.png The file icon is used in the TableCurve Studio Explorer for a data source that has been added. It is also used for the overall notebook.

tree2.png The icon changes when the data source item is expanded.

Drag and Drop

Data sources can also be added to the TableCurve Studio notebook by dragging and dropping the desired files from Windows Explorer.

Subsequent XYZ Specification

Note that adding a data source to the notebook does not define the XYZ data sets that will be specified and processed. No XYZ data sets exist after a data source is added unless the source is specifically an XYZ ASCII, SPSS.

The XYZ data sets are subsequently specified using a variety of approaches:

·    The Autospecify All XYZ Data Items option is the easiest way to specify all XYZ data sets in the entirety of a data source, such as an Excel file. This option is in the File menu and in the right click menu for the data source item, or if expanded, for the individual sheets within a spreadsheet file.

·    The Specify XYZ Data Item option is used to specify the X, Y, and Z columns for a single data set. This option is also in the File menu and in the right click menu for the individual sheets within a spreadsheet file.

·    If the data source is a three column ASCII file or an SPSS file exported from TableCurve Studio, the XYZ variables and the titles are automatically specified.

For 2D (XY) Data

For a 2D (XY) fit, this is simply called Import, and it works differently: the file is read directly into the data table immediately, rather than added as a persistent source you specify data sets from afterward. The file is opened only long enough to read the needed columns, then closed at once -- TableCurve 2D has no Open option, to conserve memory. Related options are Import Digital Filter (averages every n points), Import Clipboard, and Import Binary (fixed-length binary data blocks); Append, Append Digital Filter, and Append Clipboard combine new data with what's already in the table instead of replacing it.

Because Import reads directly into the single data table, TableCurve 2D is not designed to import multiple data sets at once -- when you have many similar data sets to process, use the Automation facility instead, which can sequentially import and process any number of them unattended. The Previous Files list at the bottom of the File menu lets you quickly reopen a recently used file.