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

  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."

    If you select Format File Defined, enter the name of the COL file, including the complete operating system path.

  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.
    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.
  10. Optional: Select "Calculate fields on form during document import."
  11. 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.