Unable to create excel file using write range in orchestrator

Help
, ,
1

I can’t able to create new excel file using the write range activity in Orchestrator. When i run the bot my local system it was perfect. Now and getting exception.

Please find the error information below.

  • “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)”.

Please someone help me on this.

Thanks,
Elam.

2

Is your robot in which you are executing the workflow different than your local system? What’s the Path of the Excel file you are giving Absolute or Relative?

Thanks,
Rammohan B.

1 Like
3

Am running in the same system. The file path is absolute.

4

Can you attach your workflow? Just curious, sheet doesn’t exist are more related to Read Range activities. I am not sure why would that appear for a Write Range. It sheet doesn’t exists then it would just create a new sheet as per the name given in the activity. Can you also make sure that you don’t have any existing file already before you run the worklfow and then check if everything works? Also, if your excel file resides in the same folder then just try giving a relative path and see if it works.

Thanks,
Rammohan B.

1 Like
5

i just recreated the workflow and its working now. I dont know where it went wrong. Thanks @Rammohan91.

Thanks,
Elamparithi.

1 Like