EXcel cell reading

Hi all,
I’m new to the world of Knime. I’m trying to read an excel file with 10 cells and convert it to a document. I inserted an excel reader followed by a GroupBy node and a Strings To Document but as soon as I go to see the output of the node the document part is empty

Hi @rizzo_antonio
I’m not sure what is your expected output, however just as an example I have connected String to Document node directly to Excel Reader node.
image
Both nodes have been executed and I’m able to view the outcome of Strings To Document node.
Could you please specify your expectations?
Please note what I’m sharing is just a graphic, not w workflow.

Regards,
Kaz

Hi, thank you for your reply. Attached my example workflow
EXcel data read.knwf (11.9 KB)
What I’m expecting is to have in Document column some data and not an empty value as it is now.
Thnak you

@rizzo_antonio please share excel file with input data. Excel Reader refers to file on your OneDrive

E033.xlsx (9.9 KB)
Ok, it’s attached. This is only an example but my overall data are in this format.
Antonio

I’m still not sure if this is something you are looking for, but please have a look:

  1. Just two nodes: Excel Reader and String to Document
    image

  2. String to Document configuration

  3. Outcome after execution

I’m also quite new to KNIME, thus started with the simplest solution.

1 Like

Thank you very much it works.

Antonio

1 Like

Happy to hear that, happy KNIMEing Antonio :slight_smile:

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