Save Front Panel Picture to Excel

[gjacob]

Hello, for my program I generate a spreadsheet with a large matrix in it (500x100) or so. Since Excel cannot produce that nice looking of a graph, I would like to export my Intensity Graph into Excel.

I have been searching the forums for a bit now and could not find the information on how to do this... I don't think the placement inside the spreadsheet is crucial, so just some advice to get the picture in there would be great.

Thanks,

gj

[AdnanZ]

Have you looked at the following link:

http://decibel.ni.com/content/docs/DOC-9901

[gjacob]

That looks like it will be useful, but I do not know what to use as the file path of the picture, because it is going to come from one of my indicators.

[Rhys - AE]

Hi there,

In order to directly interface with excel you will need the "NI LabVIEW Report Generation Toolkit for Microsoft Office". This toolkit is based on ActiveX coding.

You will be able to export a graph to Excel using ActiveX VIs yourself, but this may get complex and require a good background in coding. If you have the toolkit, the process will be far simpler.

I'm afraid ActiveX is not my specialty, so I will look into this for you and hope to get back to you over the next few days.

[AdnanZ]

You can replace that with the Append Control Image to Report VI that you will find in the Report Generation palette.

[gjacob]

Is there a way to do this without purchasing the Report Generation Toolkit?

[AdnanZ]

As Rhys mentioned, you should be able to do it using the ActiveX interface but I have never really done it that way, so sorry cannot be of much help there.

[gjacob]

One thing I did see was some function called GetBitmap or something and then you can SaveBitmaptoJPEG. I do not know if these are a part of the report generation toolkit or not, but if I just saved to a temp folder, could that work? Have you heard of these functions?

[smercurio_fc · Accepted solution]

---

@gjacob wrote:

One thing I did see was some function called GetBitmap or something and then you can SaveBitmaptoJPEG. I do not know if these are a part of the report generation toolkit or not, but if I just saved to a temp folder, could that work? Have you heard of these functions?

---

The intensity graph (as well as all the other graphs) have a "Get Image" method that you can use. You right-click on the graph and select Create -> Invoke Node -> Get Image. You can then wire the image data directly to one of the image write functions:

[gjacob]

Thanks smercurio, I'm going to go with that. I think it might actually be desirable to have the .png file and the spreadsheet file separated, so it will be good to have it this way.