![]() |
When you import an IBM® 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 an IBM Lotus Notes® form to accept the data. The field names in the form must correspond to the field names used in the Lotus 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, Lotus Notes imports only the range in the first sheet.
Lotus 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. Lotus Notes can handle a spreadsheet whose maximum text width is 22.75 inches; additional text is not displayed in the columns.
Perform the following steps: