In my table, there’s a column named ‘curve’, which is derived from the Dose Response (R) node followed by an Image to Table conversion. However, when I used the Python script for Excel output, the ‘curve’ column did not display as expected images but rather as a string similar to ‘<PIL.PngImagePlugin.PngImageFile image mode=RGBA size=800x600 at 0x127C28A10>’.
At present, the only workaround I’ve found is to save the images locally and then re-import them into Excel. However, this method is not ideal as it significantly diminishes the efficiency of my analysis, particularly when working on my laptop. While the Excel Writer node could potentially meet my requirements, it is incompatible with saving Excel files that contain both string and numeric data in the same column. Therefore, I am compelled to rely on Python scripts for this task. Your help would be greatly appreciated. Thank you in advance for your consideration and support.
@nealwzz you can place images into an Excel file from KNIME thru Python like this:
2 Likes
Thank you so much for your assistance. I have successfully managed to generate the output Excel files. Truly appreciate your help!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.