Import picture file from excel to lotus notes

HCL Domino Domino Forum
1

hiactually i want to import a excel file that contain some data and some picture and want to import that picture and data from excel to lotus notes

2

Subject: RE: import picture file from excel to lotus notes

There is no code in Notes to understand MS Office’s proprietary file formats and let you manipulate their contents. You would have to use code supplied by Microsoft – such as their OLE API – to extract the data you want. You can call the OLE functions from LotusScript. Once you have the data, in whatever way the OLE API gives it to you, then we can talk about putting it into a Notes document. But first you have to tell us what type of data you have managed to get (strings? streams? jpg files on disk?) and how you want it represented in Notes.

3

Subject: RE: import picture file from excel to lotus notes

hii created a OLE API object and imported text date but i facing problem in importing picture form excel to notes

data i want to import are:-

  1. jpg files and String

thank

4

Subject: RE: import picture file from excel to lotus notes

What does it mean to you to import a jpg file into Notes? Do you want an embedded image or a file attachment?

Is the document you want to import into, open on screen, or is this a back-end operation?

5

Subject: RE: import picture file from excel to lotus notes

hi Andrew

there is excel sheet that contains some data and some picture. i want to import that excel sheet with data and picture. i did not want image as file attachment. i want to run one agent that take the excel sheet and make it as document

and picture or image will come into document. so that if document will move futher this image will visible at other end

i hope you understand my problem more clearly

thanks

6

Subject: RE: import picture file from excel to lotus notes

It sounds like you were able to create a JPG file, so the question is no longer how do you import data from the spreadsheet, but how do you import the JPG file.

It is easy to embed an image in rich text if you are editing the document you want to put the image into. The Import method of NotesUIDocument will let your LotusScript code specify a filename and datatype (JPEG).

If you’re access the document by a NotesDocument object this is harder. You would have to create DXL code representing the rich text containing the image, and import it. This would involve base64-encoding the binary image file data.

The Midas toolkit from Genii Software might be able to help.