Jump to content
News about the LabVIEW Wiki! Read more... ×
Sign in to follow this  
LAVA 1.0 Content

jpg or bmp from LabVIEW toExcel

Recommended Posts

Hi,

i want parse some pictures (jpg or bmp) from LabVIEW to a special Mircosoft Excel Tabelle. Using Active X is very difficult.

:(

Yours sincerely Thomas

Share this post


Link to post
Share on other sites

Perhaps you could give a bit more detail about exactly what you want to do? What data do you want to send to a spreadsheet? Does something prevent you from using the simple VI that writes to a spreadsheet file?

Share this post


Link to post
Share on other sites
We have a case where we take a snapshot of a XY graph, save the image to a BMP file, and then insert the BMP to Excel. See attached code for inserting a BMP file to Excel. (am using LabVIEW 7.1.1f2 and Excel 2003)

This seems like overkill. What you are trying to do while not impossible is not how the Excel Active X interface was meant to be used. Rather than trying to find out how this would have to be worked out and then maybe the more complicated thing to try to explain it I would rather suggest to send the data to Excel instead and then start a macro in the Excel Spreadsheet that takes those data and creates an Excel Graph from it. While this may sound work intense I'm sure trying to get a LabVIEW graph properly into Excel as bitmap will be at least as hard and that would assume you know how to build a device independant bitmap in memory and transfer its handle across process bounderies.

Rolf Kalbermatter

Share this post


Link to post
Share on other sites
This seems like overkill. What you are trying to do while not impossible is not how the Excel Active X interface was meant to be used. Rather than trying to find out how this would have to be worked out and then maybe the more complicated thing to try to explain it I would rather suggest to send the data to Excel instead and then start a macro in the Excel Spreadsheet that takes those data and creates an Excel Graph from it. While this may sound work intense I'm sure trying to get a LabVIEW graph properly into Excel as bitmap will be at least as hard and that would assume you know how to build a device independant bitmap in memory and transfer its handle across process bounderies.

Rolf Kalbermatter

I agree that a native Excel graph is better as the end user can do their own manipulations of the data and so forth. In our case, we provided another worksheet with the rawdata for their own manipulation. Also, to get Excel to format that was a bit time consuming (it seemed at least) and with the variations of the versions, we viewed that as an additional risk.

Share this post


Link to post
Share on other sites

This seems like overkill. What you are trying to do while not impossible is not how the Excel Active X interface was meant to be used. Rather than trying to find out how this would have to be worked out and then maybe the more complicated thing to try to explain it I would rather suggest to send the data to Excel instead and then start a macro in the Excel Spreadsheet that takes those data and creates an Excel Graph from it. While this may sound work intense I'm sure trying to get a LabVIEW graph properly into Excel as bitmap will be at least as hard and that would assume you know how to build a device independant bitmap in memory and transfer its handle across process bounderies.

Rolf Kalbermatter

Where can I get the VI for copying Bmp or Jpeg from Labview to Excel?

Help me out Please.

Thanks,

Suresh

Share this post


Link to post
Share on other sites

Try this. It copies a control's picture into the clipboard. Then you can paste from the clipboard into Excel.

Let me know if you are missing some VIs. I think some of the subVIs use OpenG VIs, so I hope you have that installed.

Insert Pic.zip

Share this post


Link to post
Share on other sites

Try this. It copies a control's picture into the clipboard. Then you can paste from the clipboard into Excel.

Let me know if you are missing some VIs. I think some of the subVIs use OpenG VIs, so I hope you have that installed.

Thanks a lot. I will check and get back to you on the same.

Suresh

Share this post


Link to post
Share on other sites

Try this. It copies a control's picture into the clipboard. Then you can paste from the clipboard into Excel.

Let me know if you are missing some VIs. I think some of the subVIs use OpenG VIs, so I hope you have that installed.

Is it possible to send the graph from LabVIEW 8.6 to Excel directly?

Thanjks,

Suresh

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.