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