Importing worksheets
About this task
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.
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
About this task
The source file containing the worksheet must be on your local hard drive or on a file server to which you are connected.
Procedure
- Select the database and open the view that will receive the source data.
- Choose File - Import.
- Select the name of the source file.
- Select "123 Worksheet."
- Click Import.
- Select a form to use for the imported source data from the "Use Form" list.
- Leave Main Document(s) selected in the "Import as" list, unless you are creating response documents.
- Select a "Column format."
If you select Format File Defined, enter the name of the COL file, including the complete operating system path.
- 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.
Note: If you import a multiple-sheet worksheet file, Domino® imports only the sheet that was open when the file was last closed, or, if importing a specified range, imports the range from that sheet.
- Optional: Select "Calculate fields on form during document import."
- Click OK.
Results
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.