I have a process , which reads the user data from an Excel file and then save the data to a website to register the user.
When I am using the process through the UI studio the execution is successful, however, when I am trying to do the same using Orchestrator, getting an error as sheet doesn’t exist
Info: “Execution error : System.ArgumentException: The sheet does not exist.\r\n at UiPath.Excel.WorkbookApplication.SetSheet(String sheetName, Boolean createNew)\r\n at UiPath.Excel.Activities.ExcelInteropActivity`1.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)”
I have mentioned and kept the excel file in the desired location, also all other excel files are closed, but the job is getting failed at the beginning while trying to read the excel file as unable to find sheet.
Do i need to keep the file in a specific location? or need to modify the path
I am Running in the same machine in which I have configured my bot.
What i found that, while running through the Orchestrator need to make the excel file path as Absolute , not relative. Relative path works in UI studio, but in Orchestrator need to make the path as absolute.