Read Range throwing exception '"Invalid Hyperlink: Malformed URI..."

excel

#1

I am reading an excel file using Read range activity and it throws me exception “Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document, Exception type: OpenXmlPackageException”. I have attached the excel with dummy data. If i delete some data from sheet “Data”, then it works fine. But i can not do it in the live environment. Please let me know how it can be resolved. Similar problem is discussed in thread While Reading the Excel throw exception but no resolution.

Read%20Range Dummy Data Copy.xlsx (18.9 KB)


#2

Hlo pardeepMittal

you can use excel application scope for this type of error.


#3

Thanks Pranesh! It is working fine with excel application scope. Could you also tell me the reason behind it. As Read range(even without excel scope) worked fine for me always but this case.


#4

ya workbook also works. but the background code(macros) may differ.