jpg or bmp from LabVIEW toExcel

[LAVA 1.0 Content]

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

[Steve]

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?

[TerryS]

[quote name='ThomasM

[Rolf Kalbermatter]

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

[LAVA 1.0 Content]

Thanks Terry Stratoudakis for this VI. It works perfect. :thumbup:

[TerryS]

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.

[g_sures]

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

[ooth]

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

[g_sures]

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

[g_sures]

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