Insert - Data

The Data menu selection under the Insert menu allows you to import or export data in one of three ways and in a variety of formats.

File Input

Inserts a component into your worksheet that reads from data files in the following formats: ASCII text, MATLAB, Microsoft Excel, Lotus 1-2-3, Quattro Pro, and dBase III. This component can be recalculated to read data again if the file has changed.

File Output

Inserts a component into your worksheet that writes to a data file in one of the following formats: ASCII text, MATLAB, Microsoft Excel, Lotus 1-2-3, Quattro Pro, and dBase III. There are additional options for using tabs, commas, or spaces in text file output. This component can be recalculated to write data again if the data has changed.

Table

Inserts a component into your worksheet that reads from the same types of data files supported by the other data components. Data Tables read data only once; a link to the file is not maintained.

You can modify the number of rows or columns of data that are read, or, in the case of Excel spreadsheets, specify named ranges or cell ranges. You can change these settings either when the component is created, or by right-clicking on the component and choosing Properties from the resulting menu.

Notes: