topic Re: How to obtain image from excel using activex in LabVIEW

How to obtain image from excel using activex

AndrewAG — Wed, 16 Apr 2008 10:00:18 GMT

The program I'm building first sends a jpeg to excel using the first attached vi. What I need to be able to do is retrieve the image from said file using Activex. It's fairly simple to retrieve individual strings and values from cells, but I'm not sure how to redisplay an image in LabVIEW once it's in excel.

Anyone know how to resolve this?

The first file I've attached shows how the image gets into excel - the usual way I gleamed from reading these boards.

The second shows my vi retrieving a number from one of the cells in excel - not an image

Thank you all for your help!

Re: How to obtain image from excel using activex

MikeS81 — Wed, 16 Apr 2008 13:21:52 GMT

Hi AndrewAG,

you can use the CopyPicture function. See the attached example. The cases with the yellow background should be interesting for you. First i use your function to add a picture ("the brain.jpg" from tst) into the first worksheet. Then i read it with the CopyFunction, so that it is available in the clipbord and then i read it from the clipboard to save it as (bmp, jpg or png), the example works with bmp. You have to clear the errors in the clipboard vi, but they are there because of i save it for LV80.

Hope this helps.

Mike

Re: How to obtain image from excel using activex

AndrewAG — Thu, 17 Apr 2008 19:39:16 GMT

This is fantastic! Thank you so very much.

-AndrewAG

Re: How to obtain image from excel using activex

GokulGKM — Sun, 10 Jan 2016 17:08:22 GMT

can ur send me this Example labview8.2 format.

Re: How to obtain image from excel using activex

ben64 — Sun, 10 Jan 2016 17:46:11 GMT

GokulGKM a écrit :

hi

can ur send me this Example labview8.2 format.

Have you ried to open it? The zip file indicate that it is in version 8.0, you should be able to open it with LabVIEW 8.2.

Ben64

Re: How to obtain image from excel using activex

GokulGKM — Mon, 11 Jan 2016 05:36:37 GMT

ya thanks i got solution....