Excel Writer : Execution failed: ("Array out of bound exception")

Dear Knimeforum,

the excel writer fails with an “Array out of bound exception” if the table to be written contains
Images (Rendere to Image node : png from RDkit 2D depiction).

The number which appears in the exception is the number of column minus the number of column containing the png (at least in my case).

I am using KNIME 4.3.0 on CentOS8.

best regards,
Simon

Would it be possible to share the workflow or table or a part of it with us. Makes it easier for us to reproduce the problem.

Best
Mark

ExcelWriterin.xlsx (3.5 KB)

Please find attached a picture of the workflow (simplified version) and an input table - which has been shortened. I would also be happy to upload the workflow if needed.

Many thanks for your help!

regards,
Simon

1 Like

ExcelWriter.knwf (12.8 KB)
Pleae find attached the workflow.

1 Like

Thx for the workflow. Currently looking into the problem. I’ll keep you posted

@Simon_Ruedisser,

I already fixed the issue and I think it will be made available with 4.3.1, which will be released in the next couple of weeks.

Could you do me another favor. Please move the PNG column to the very first column (Column Resorter node) this should allow you to execute the node. Is the output you’re seeing as expected?

Best,
Mark

3 Likes

After moving the PNG column to the first column I get the expected result:
The table is written as xlsx with the correct images.

Many thanks for your help!!

best regards,
Simon

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.