How to delete the excel file in Orchestrator

Learning Hub Academy Feedback
1

I cannot able to delete the excel file after deploying in live. I have defined the file dynamically and am not getting any error either. Can someone please help me on this.

2

what activity you are using to delete file…?

3

delete activity.

4

Is your path defined somewhere or it is hardcoded?

5

Thanks for the response @PrankurJoshi @phyogananda

Now i can able to delete the file but now am unable to create new excel sheet. Can you please help on this.

1 Like
6

What are you using to create an excel? If you are using Excel Application Scope it would automatically create if a file does not exist

7

I am using Excel application scope only, when i tried before deploying it to orchestrator its working fine. After deploying to orchestrator its not creating the excel file.

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)”
1 Like
8

Are you running the bot on same machine on which you have the Studio or somewhere else? Do you have microsoft office installed there? Also please check the path what you have given. See this -

3 Likes
9

Thanks @PrankurJoshi. This helped me to solve my issue.

Thanks,
Elamparithi.

1 Like
10

Great close the thread by checking solution checkbox it will help others too then

11

Thanks :slight_smile:

1 Like