APPLICATION DESIGN

Importing worksheets
Before you import a worksheet, you must create a form and a view to hold the imported data. When you import a worksheet into the view, each worksheet row becomes an individual document, and each worksheet column becomes a field. The original cell contents become the field contents. You can import data into either main documents or response documents.

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

To import worksheet data into a view

The source file containing the worksheet must be on your local hard drive or on a file server to which you are connected.

1. Select the database and open the view that will receive the source data.

2. Choose File - Import.

3. Select the name of the source file.

4. Select "123 Worksheet."

5. Click Import.

6. Select a form to use for the imported source data from the "Use Form" list.

7. Leave Main Document(s) selected in the "Import as" list, unless you are creating response documents.

8. Select a "Column format."


9. To import part of a worksheet, type a range name or range address in the WKS Range Name box. You cannot import a 3-D range.
10. (Optional) Select "Calculate fields on form during document import."

11. Click OK.

After importing, you can change the column font to a proportional space font, such as Courier, in the view design pane to improve the display of worksheet data.

See Also