How to get the text inside comments in an Excel file

[FVarlet]

Hello,

I have Excel files with comments attached to some cells.
Is there a way to get the text in these comments, and paste them for example in a column?

Thank you in advance for your help

[gonhaddock]

Hello @FVarlet
I don’t know how to do it in KNIME , however if you can code in R, #tidyxl can be a way to go.

Extracting comments inserted in Excel spreadsheets

BR

[victor_palacios]

Hello,

We currently do not have this ability, but I have created an internal ticket for this. Thank you for the idea.

[FVarlet]

Hello,

Thanks to both of you. I’ll try to do it with R, but I don’t know R yet.
I hope we can see this functionality soon

[duristef]

Another (winding) way would be to save the Excel file in html format, parse it with “Html Parser” and perform this Xpath query on the XML Document it returns

[FVarlet]

Thanks for the tip.
Unfortunately, that will not work in my case, or I will have to do it with all Excel files continuously.