Continuing the discussion from How to get the text inside comments in an Excel file:
Hi @victor_palacios, was there ever an update to the ticket mentioned above?
I’d prefer an option within the existing Excel nodes, or a new node, rather than R/Python solutions.
hi @sauberns, if you are on KNIME AP 4.7, you can give this a try:
It needs KNIME 4.7 to work though, and a known limitation is that it cannot read “threaded comments” as these aren’t supported by the available java package bundles that it uses.
Demo workflow here:
@sauberns , hello. Unfortunately, no update to the ticket. @takbb , thank you kindly for this solution.
@sauberns here is an approach using OpenPyxl which is part of the bundled Python Integration of KNIME:
kn_example_python_excel_read_comments.knwf (78.5 KB)
Wow. Thanks @takbb , that works perfectly for our needs.
Thanks @mlauber71. I think that will be useful for my own work, and I’ll have to have a bit of a play around to see how to distribute that as a solution for our end users.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.