Write to Excel so the pictures are placed in cell and alt text is included

[iCFO]

I would recommend the write to Excel Template to maintain the formatting and existing programming / references in other cells. Here is a workflow that I uploaded a few days ago that writes both png images and string values into a template file.

Paste screenshot in Excel file

Write images to Excel.knwf (528.1 KB) Here are examples of how to write image files to excel using the Write to Excel Template node. I included a component that you can use to quickly access the workflow data folder or launch the excel files. Just execute it and open the interactive view, then you trigger a one time open by changing the dropdown to yes and hit refresh to open a file or folder selected to right. Works the same if you use Write to Excel. The template approach just simplifies for…

For a simple solutions, I would just write the text to another column and reference it for filtering via drop-down. You can always hide the referenced filter column in the template file.

Adding alt text specifically might be possible via Python openPyXL.