While Reading the Excel throw exception

Help
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

1 Like
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

5

did you get any solution for this

6

Hi @niteshvnr

Could you attach an example Excel file? I have trouble reproducing the issue on Excel activity package 2.5.3.

Please update the activity package here and see if it will work then :slight_smile:

image
image1108Ă—166 11.9 KB