Read range: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document

Hello all,

I currently having a constant error, I have an excel that contains passwords of users and on some occasions, the special characters used such as @ or . cause a hyperlink to appear.

I only need to read range the text in the cells but I keep getting the error message as above:
Read range: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.

Is there anyway to change the settings that it will ignore hyperlinks and just focus on the text in the document?

If the data in the sheet is not too large, please check the Preserve Format property in the Read Range activity. This should solve the URI issue because the whole sheet will be read as it is seen in the excel file.