Excel Reader cannot read excel data with hyperlinks

[zebra]

Hello everyone，

Excel Reader cannot read excel data with hyperlinks；
How to fix it？
Thank you

[ScottF]

Hi @zebra and welcome to the forum.

Do you have an example spreadsheet and workflow that you could upload that showcases the problem? Perhaps this is some type of encoding issue.

[rfeigel]

Check this:

Extract http-link from Excel-content

Interesting challenge. I don’t think this can be solved using the Excel Reader. I had a quick play with a Python Script Node assisted by K-AI - however had to manually debug a little as well: [image] Here’s an image incl. those topics that I had to manually modify: [image] Path to file - K-AI tried to load the file from the root of the knime workspace so I had to adjust it - the “r” ahead of the string is important to avoid escaped charcters etc. row / column: K-AI tried to start from row…

[zebra]

Hello,
First of all, thank you for your reply. I am sorry that my English is very poor. I use Google Translate most of the time.
I am very sorry that I cannot upload this spreadsheet using the external network because it exists in the company’s internal workspace and has dynamic reading permissions set. After my investigation, I found that the reading error is related to the data format;
Finally, thank you again for your reply and answering questions. Thank you

[zebra]

Thanks for your reply, I will try it with python