Home
Sharing information with other applications
You can share files and graphics between HCL Notes® and other applications using a number of different techniques.
Working with shared information
These tasks explain how to import and export data between Notes and other applications.
Importing files into documents that have rich-text fields
You can import text files, word processing files, HTML files, graphics files, and spreadsheet files into documents that have rich-text fields, as long as the source file is stored in a location you can access, such as your local hard disk drive or file server.
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.

Sharing information with other applications
You can share files and graphics between HCL Notes® and other applications using a number of different techniques.
- Getting started with sharing information
  These tasks explain how to copy data into Notes, and how to share your Notes data with other applications.
- Sharing information with other applications quick reference
  This quick reference card is a list of instructions for common tasks and shortcuts for sharing information with other applications, which you can print and keep at your desk for easy reference.
- Working with shared information
  These tasks explain how to import and export data between Notes and other applications.
  - Importing and exporting
    You can import data from many popular applications into a HCL Notes® document or view, and export data from a Notes document or view into many of the same applications.
  - Importing files into documents that have rich-text fields
    You can import text files, word processing files, HTML files, graphics files, and spreadsheet files into documents that have rich-text fields, as long as the source file is stored in a location you can access, such as your local hard disk drive or file server.
    - Importing text files
      You can import rich-text files, ASCII text files, and word processing files into a rich-text field in an HCL Notes® document.
    - How can I import HTML files?
      You can import the text of an HTML file, and the graphics if they are stored locally, into an HCL Notes® rich-text field.
    - How can I import graphics files?
      You can import several types of graphics files -- BMP, CGM, GIF, JPEG, ® PIC, PCX, and TIFF 5.0 -- into a rich-text field in an HCL Notes® document.
    - 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.
  - Exporting documents into text files
    You can export documents into rich-text files and word processing files.
- Advanced shared information topics
  These tasks describe how to work with object linking and embedding, and how to import or export formatted data.

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.

About this task

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.

Perform the following steps:

Procedure

Edit the document, and then click where you want the imported file to appear.
Click File > Import. (This option is dim if the field you have clicked is not a rich-text field.)
Click the spreadsheet program for the file you are importing in the Files of type list.
Select the file's drive and directory and then select the file.
Click Import.