Inserting, importing, and combining files
Quattro Pro lets you insert a file into a notebook.
You can also import both delimited and fixed-width text files. When you import text, you can specify how the text should be arranged on the spreadsheet. Arranging data into columns and rows is called parsing. For example, you can parse a column of long labels into two or more columns of data.
When you open a text file that includes tabs indicating new segments of data, Quattro Pro starts a new column each time it encounters a tab in the text.
Every sheet in the inserted or imported file that contains data is placed on a new sheet in the active notebook. If only one sheet is inserted, the sheet is given the name of the inserted file. If multiple sheets are inserted, the new sheets are named in the default letter sequence.
You can save notebooks as tab- or comma-delimited text files.
You can also import unformatted text.
You can combine files by adding, subtracting, multiplying, or dividing the cells of two notebooks. You can also combine files by using math operators. Adding data is useful for combining files for a cumulative total. For example, you could compile year-to-date figures from monthly notebooks to create a cumulative notebook showing year-to-date expense totals.
For additional information, see “Rules for combining files.”
To insert a file into a notebook |  |
|
1.
|
|
Close the file you want to insert.
|
|
2.
|
|
Click Insert
 Insert file. |
|
3.
|
|
Choose a filename.
|
|
If you want to insert a file from another application, include its filename extension.
|
|
4.
|
|
Type the cell location before which you want to place the inserted file in the Before sheet box.
|
|
•
|
|
If the file is inserted within the boundaries of a named selection of cells, or cells referenced by a formula, references expand to include the new spreadsheets.
|
|
•
|
|
If inserting a file expands a named selection of cells or cell reference beyond the limit of a notebook (beyond spreadsheet ZZZ), the reference becomes ERR.
|
To import a text file | |
|
1.
|
|
Click File
Open. |
|
2.
|
|
Choose the drive and folder where the file is stored.
|
|
3.
|
|
Choose ASCII Text (*.txt) from the File type list box.
|
|
4.
|
|
Double-click the filename.
|
|
5.
|
|
From the Parse settings list box, choose one of the following:
|
|
•
|
Automatic — automatically determines how best to parse the imported text file
|
|
•
|
Delimited auto — automatically parses imported delimited text files
|
|
•
|
Fixed width auto — automatically parses imported fixed-width text files
|
|
•
|
|
Lines larger than 4 KB are not imported. If the total number of lines (rows) you import exceeds the limit of the number of rows you specified for a spreadsheet, the data is truncated to this limit.
|
To save a text file | |
|
1.
|
|
Select a cell on the relevant sheet.
|
|
2.
|
|
Click File
Save as. |
|
3.
|
|
Type the filename with the extension .txt in the Filename box.
|
|
4.
|
|
Choose ASCII Text (tab delimited or comma delimited) from the File type list box.
|
|
•
|
|
Only the contents of the current sheet (or, if it is empty, the first non-empty sheet) of a notebook are saved.
|
To import unformatted text | |
|
1.
|
|
In the source application, select the data to paste into Quattro Pro.
|
|
2.
|
|
Click Edit
Copy. |
|
3.
|
|
In Quattro Pro, click Edit
Paste special. |
|
4.
|
|
Choose Unformatted text from the As box.
|
|
5.
|
|
Enable the Paste option.
|
To combine files by using math operations | |
|
1.
|
|
Click File
Open. |
|
2.
|
|
Choose the drive and folder where the destination notebook is stored.
|
|
3.
|
|
Double-click the filename.
|
|
This notebook contains the existing values; data in this notebook will be altered.
|
|
4.
|
|
Click Tools
Data tools Combine files. |
|
5.
|
|
Click the Browse
 button, and select the source notebook. |
|
This notebook contains the incoming values; no changes are made to this notebook.
|
|
6.
|
|
In the Source area, enable one of the following options:
|
|
•
|
Entire file — combines all data in the two files
|
|
•
|
Cell(s) — combines only data in the cells which you specify
|
|
7.
|
|
In the Operation area, enable one of the following options:
|
|
•
|
Copy — inserts the exact contents of the source notebook
|
|
•
|
Add — adds the incoming values to the existing values
|
|
•
|
Subtract — subtracts the incoming values from the existing values
|
|
•
|
Multiply — multiplies the incoming values by the existing values
|
|
•
|
Divide — divides the existing values by the incoming values
|
|
•
|
|
For additional information, see “Rules for combining files.”
|
|
•
|
|
You can also combine files by copying the data from the source notebook and pasting it over the corresponding data in the destination notebook with the Paste special command.
|