While Reading the Excel throw exception


#1

While reading the excel through a exception like,

Exception : DocumentFormat.OpenXml.Packaging.OpenXmlPackageException: Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document.\r\n at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.Load()\r\n at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.OpenCore(String path, Boolean readWriteMode)\r\n at DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Open(String path, Boolean isEditable, OpenSettings openSettings)\r\n at ClosedXML.Excel.XLWorkbook.LoadSheets(String fileName) in C:\Projects\ClosedXML\ClosedXML\Excel\XLWorkbook_Load.cs:line 44\r\n at UiPath.Excel.WorkbookFile…ctor(String workbookPath, Boolean createNew)\r\n at UiPath.Excel.Activities.WorkbookActivity1.ConstructWorkbook(String path, String password, Boolean createNew)\r\n at UiPath.Excel.Activities.WorkbookActivity1.BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, Object state)\r\n at System.Activities.AsyncCodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)\r\n at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)\r\n at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

One of the column value in that excel is like “Password@123*” ,If I changed that format to normal its working.

Anybody knows kindly give solution for the above issue.

Thanks,
Tharma KS


#2

Is it possible for you to attach your excel and workflow?

Thanks,
Rammohan B.


#3

We can read the excel by removing the hyperlink value in the cells


#4

@Sharathk

Ya it’s working but in live we can’t force user to do the changes like that, so kindly suggest better solution.

Thanks,
Tharma KS