How to get the text inside comments in an Excel file

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

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

BR

4 Likes

Hello,

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

4 Likes

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

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

3 Likes

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

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