Hello Boone,
We can divide your task into two main sub-tasks: First is getting the picture from your LV front-panel saved as an image to the disk (even if it's temporary).
Second is to insert this saved image into your Excel report.
For the first task, you may either use the Get Panel Image method on the VI which will capture the entire front-panel as an image. Or, use the Get Image method on a Control. For instance, you may use the Tab Control with its tabs hidden as a container for your picture. This way you can capture just the picture. Since I am on LabVIEW 7.0, I am attaching a screenshot which shows the first option (fpcaptre.png).
The seconds task of inserting this image in your Excel report is a l
ittle tricky. You basically use the ActiveX interface to Excel to do this. This involves opening an Automation refnum to Excel first, then to the ActiveWorkbook, and then to the ActiveSheet. On this ActiveSheet we call the AddPicture method under Shapes. This AddPicture method allows you to specify which picture, where in your Excel sheet you want to insert the picture, etc. Again, I am attaching a screenshot for this as well (addpicxl.png).
I am also attaching the VI for those with LV 7.0 (pastexcel.vi). Disclaimer: this VI was put together in a jiffy to demo the concepts only, it can definitely be improved further, blah blah blah 🙂
Hope this helps.
Regards,
Khalid
