How can I import spreadsheet files into documents that have rich-text fields?

You can import Microsoft Excel spreadsheet files into a rich-text field in a document. An imported spreadsheet becomes a table.

A proposito di questo compito

Note: To find out whether or not the field you want to import to is a rich-text field, click that field, and click Edit > Document Properties (switch to Document if necessary). Then click Fields (second tab) and the field name in the left box. In the right box, any rich-text field is listed as Data Type: Rich Text.

If a spreadsheet is wider than an HCL Notes® window, use the horizontal scroll bar to see the rest of the data. The widest text can be in a Notes® document is 22.75 inches. Additional text does not appear. Also, Notes® imports only the first 64 columns of the spreadsheet.

If the spreadsheet file contains multiple sheets, only the first sheet is imported. Notes® also doesn't import names of named ranges.

Notes® changes the font in Microsoft Excel imports to Times Roman. Once the file is imported, you can change the font.

Eseguire i seguenti passaggi:

Procedura

  1. Edit the document, and then click where you want the imported file to appear.
  2. Click File > Import. (This option is dim if the field you have clicked is not a rich-text field.)
  3. Selezionare l'unità e la directory del file, quindi selezionare il file.
  4. Fare clic su Importa .