Excel Sporadic Error

excel
activities
p_qa
hotkey

#1

Below error is occuring sporadically at Workbook Write Range activity since last week in production and neither code nor activity have been modified. But when we restart the bot, it works fine.

Any idea why it occurs or is it a known issue. Just wanted to check here before we investigate further.

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: The cells A2 and M1 are outside the range ‘‘Sheet1’!A1:M1’. at UiPath.Core.Activities.InvokeWorkflowFile.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

We also get below sporadic error on the same machine which has been confirmed as a known issue on slow machines by @Gabriel_Tatu .This happens for Send Hot Key activity and Machine reboot fixes this issue.

UiPath.Core.ElementOperationException: Write text failed. —> System.Runtime.InteropServices.COMException: Synthetizing keys failure. at UiPath.UiNodeClass.WriteText(String text, UiInputMethod inputMethod) at UiPath.Core.UiElement.WriteText(String text, InputMethod method) — End of inner exception stack trace — at UiPath.Core.Activities.InvokeWorkflowFile.EndExecute(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result) at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)


#2

Can you share a small workflow where this reproduces so we can test?
The second one is fixed in 18.1


#3

I’m not sure if I can reproduce this error as this is happening on a specific machine and that too randomly. I will try to create one.


#4

The issue was with WorkBook Write Range Activity and the reason is Filter was ON in the spreadsheet. But when we run for the second time the keeping the filter ON, it works fine.The write range basically creates a new sheet in the same spreadsheet. I noticed that the it creates the Sheet, but writes the data in a different format in 1st attempt in spite of the error. Is it a general behavior?


#5

I will have to try it and then get back to you.


#6

check my attachment. its working fine for me (ran it 1000 times) h.zip (1.5 MB)


#7

pm’ed the sample excel


#8

I will try it, thanks.


#9

Were you able to solve this issue? I am having the same problem.
While troubleshooting I have learned that it has to deal with the excel spreadsheet itself, and not necessarily anything to do with UiPath.
The sheet that is giving me problems is not read or written to by the bot. If I delete the sheet, it runs just fine. If I delete the rows that the error mentions, then it runs just fine.


#10

I’ve narrowed it down further… I missed the part about the filter. Once I turned it off it worked.