Excel Sporadic Error

Help
,
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?

2 Likes
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.

1 Like
11

Getting the same error can anyone help please.
image

12

Same error occurred at my end also. The only problem which I found with the Write Cell activity of Workbook. some Xml has broken my excel and when I tried to open the excel file it is giving me repair option.
Solution: Repair your excel and Save a Copy of it and then replace it with original file

13

On a second run in production, a file that gets re-used by the bot was edited by the business to include filters, causing our automation to fail. We removed the filters and have not experienced the error since. Thank you for the information!