how to insert a picture into excel file like a copy while not a link

[qq12345678]

Hi,

  when using labview "append Image to" function to insert a picture into excel file, it seems like a link while not a copy. It means the picture in the excel file will change if the source image file is changed. 

Test steps:

1. use test_report.vi to generate test.xlsx file. It will insert temp.png into test.xlsx file.

2. open test.xlsx file, the picture is correct. 

3. make some changes on the picture file, for example, inverse the color and save it with the same name. 

4. re-open test.xlsx and it is found that the picture is also changed. 

So it looks like the picture in the excel file is a link. 

How can I insert a picture into the excel file as a copy, that means the picture in the excel file will not change even if the source picture is changed?

Thanks!

attached the vi and the generated excel file. 

[Bob_Schor · Accepted solution]

I believe this is a "feature", and not a "bug".  The Help for Append Image to Report clearly describes the input terminal as a link to the Image.  As LabVIEW doesn't know the internal workings of Excel, it just hands Excel a reference to the Image, and lets Excel "do its thing".

If you want to prevent changing the Image, make the input file "Read Only" or "hide" it by moving it somewhere (and possibly changing its name).

Bob Schor

[qq12345678]

Bob,

   Thanks for your comment! I checked the help and found the description. 

Thanks!