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.
이 작업 정보
Note: To find out whether or not the field you
want to import to is a rich-text field, click that field, and click (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.
다음 단계를 수행하십시오.
절차
- Edit the document, and then click where you want the imported file to appear.
- Click . (This option is dim if the field you have clicked is not a rich-text field.)
- 파일의 드라이브와 디렉터리를 선택한 다음 파일을 선택합니다.
- 가져오기 를 클릭합니다.