Excel read range - Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document

Hi All,

i try to read an excel table using read range. but some of the excel files throw me such error - Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.

Anyone know got the idea on how can fix this issue ?

thanks

@goh6613

Could you please tell more details and steps you followed to do this.

Hi, i tried both workbook read range and excel read range to read the value in excel (eg. A1:M20).
Thanks

@ goh6613
i do not know what type of data you store in your excel file, i had the same error message, i solved it - in excel file, i had a column for the email address. it came out that some emails address were not well written. for example .com was ,com an it generate this invalid hyperlink error.
hence i advice you should check if the data in your excel file are entered correctly according to the datatype.
hope this help,

thanks

1 Like

Note to Anonymous:
Please avoid using the email IDs separated by semi-colons. In my case it was causing issue even I was removing the hyperlink. Instead use the comma.