SHARING INFORMATION WITH OTHER APPLICATIONS

Importing Lotus 1-2-3 spreadsheet files into views
When you import a Lotus 1-2-3 spreadsheet file into a view, each row becomes an individual document and each column becomes a field. The original cell contents become the field contents. You can import data into either main documents or response documents.

When importing a spreadsheet file into a view, you must select a Notes form to accept the data. The field names in the form must correspond to the field names used in the Notes view (for example, name, address, phone number, and so on.).

If the spreadsheet file contains multiple sheets, only the first sheet is imported. If the range (or specified section) that you want to import spans more than one sheet within the file, Notes imports only the range in the first sheet.

Notes doesn't wrap lines of an imported spreadsheet. If the file has more columns than a window can display, use the horizontal scroll bars to see the full width of the spreadsheet. Notes can handle a spreadsheet whose maximum text width is 22.75 inches; additional text is not displayed in the columns.

To import spreadsheets into views

1. In a view, choose File - Import.

2. In the Import dialog box, select "Lotus 1-2-3" in the "Files by type" list.

3. Select the file's drive and directory and then select the file.

4. Click Import.

5. In the "1-2-3 Worksheet Import" dialog box, from the "Import as" list, select "Main Document" or "Response Document" according to how you want the spreadsheet file to appear in the view.

6. From the "Using form" list, select the Notes form you want to use to accept the data.

7. If the spreadsheet file and view have different formats, you need to use a format file so individual components correspond to the columns in the view or the fields in the document. Select "Defined by a Format File" and enter the file name in the "COL file name" box. A format file has the extension .COL and is sometimes called a column descriptor file.

8. If you have a specific named range in the spreadsheet file set up to use for the import, specify the range in the "WKS Range name" box.

9. If in step 6 you selected a form in which fields need to be calculated, select "Calculate fields on form during document import." This may be the case if you have formulas in your spreadsheet file. If unsure, ask the database designer about the form.

10. Click OK.