JPG image to excel cell

[Craig_Adam]

Hello, I have spent some time having a good look through the various posts on the forum and have got so far with my attept to place a JPG file into a specific area on an Excel spreadsheet.

To give some back ground knowledge the project i have written has the user fill in a pre test information page including the addition of a picture of the item under test. After the test, the user is given a post test page of information to complete before exiting to save data. The project then opens an Excel template and places the data both sampled and user inputed into the file. I would really like to also place the JPG image from the pre test to the Excel file in a specific area of cells. I have reduced the JPG image to a thumb nail size, so resizing is not an issue but placing the image on say a particular cell would be my goal. I have attache images of how far i have got & what i am trying to achieve im afraid my knowledge in this area is short. Thanking you now for any replies i may receive. 

[smercurio_fc]

Which part are you having problems with? How to use the AddPicture method, or how to save the JPEG that you seem have in the picture control to file? For the former, that would be in the Excel automation help file. For the latter you will need to save the picture to file. You can use the Picture to Pixmap function to get your image data and then wire that to the Write JPEG File to save the file to disk. You can then wire the path to the AddPicture method.

[Craig_Adam]

Hi,

Just so i can understand, I have the image already called from a saved file location as the picture was taken with a digital camera. During the running of the vi. th user clicks an ADD PICTURE button and is then asked to choose the image from a file. This JPG data is added to the main loop.

Are you saying that i have to save this image to a file and then input this file location to the addpicture filename connector? 

I have already tried to add the file location of the original file to the addpicture connector but this didn't work, I may have been close but still no image apeared in the Excel spreadsheet. 

Do you have any example code to look at? I would be most grateful. 

[Craig_Adam]

I have managed to do it. I was going about it the right way i just needed to make sure the path to the file made it to the vi.

Thanks for your help. 

[muks]

Just a thought .I use activex all the time. Have look might me useful