Malformed URI and OpenSettings.RelationshipErrorRewriter

[Baba_Karim_Abdulai]

Read range (Settings and Constants sheets): A malformed URI was found in the document. Please provide a OpenSettings.RelationshipErrorRewriter to handle these errors while opening a package.

Please help with this challenge.

[ashokkarale]

@Baba_Karim_Abdulai,

Refer this tutorial:

SOLUTION - UiPath Invalid Hyperlink : Malformed URI is embedded as a hyperlink in the document Range

[Anil_G (Anil Gorthi)]

@Baba_Karim_Abdulai

looks like you have hyperlinks in your config…just select all cells and remove hyperlinks that should sort the issue

cheers

[Mohite_Bhushan]

In case of error "Read range (Settings and Constants sheets): A malformed URI was found in the document. Please provide a OpenSettings.RelationshipErrorRewriter to handle these errors while opening a package. "
Solution is: Remove hyperlink from any email value present in excel

[Bhojne_Priyanka (Priyanka Bhojne)]

hi This error usually happens when the Excel file is corrupted or has invalid links. Try opening the file manually and checking for broken hyperlinks or external connections. If that doesn’t work, save the file as a new .xlsx and retry the Read Range activity