How to write image to xlsx

[Nando88]

I have been able to write data to a csv with the write to spreadsheet vi, but that only allows me to write text to a cell, I am now trying to use the vision development module, and I need to place the image that I will analyze in a cell of the spreadsheet in a xlsx, instead of a csv.

I know that there is an xlsx addon in the VI Package Manager, but I am not quite sure if I can write images to the spreadsheet, as I would if it was a line of text. The addon I installed is called CLAUDIE_xlsx.

What I wish to do is add the image in a build array and build my table from there.

Can someone please give me some advice on how I can do this?

Thanks in advance.

[Nando88 · Accepted solution]

It seems that the add-on can only write strings to an xlsx file, so I found a workaround. All that would be needed is to write the paths of the images in a column, and then run a vba script I found here:

 https://www.extendoffice.com/documents/excel/5046-excel-display-image-from-file-path.html, to convert the paths to images.

[GerdW]

Hi Nando,

have you tried to use the RGT (ReportGenerationToolkit), that comes with LabVIEW?

It's made to create documents using MSOffice software remotely…