Error: job stopped bla bla~ & How to write range excel formula without using excel app scope & the formula must showing its result (not showing the formula it self as text)

Help Activities
1

Option 1:
Write range workbook to write formula return the formula it self as text.
Impact: have to manually click the formula & press enter or have to manually “replace all” ‘=‘ with ‘=‘ to force refresh the text formula as real formula

Option 2:
Write range excel inside excel app scope return the value of the formula.
Impact: when write into excel with massive amount of sheets, the excel app scope error before running its child activities.
And the error is can’t be handled by “retry scope activity” so i’m doomed. Retry scope activity can’t catch this error, this error too amazing!
The error is written as: “job stopped in unexpected bla bla bla~”
While in powerful device, the flow run completely fine.

Any alternative idea to:

  • write range formula but the formula have to show its result, and
  • without load the excel file first before write range, because the excel file is heavy for the hardware & UiPath.

???

2

@wija

You can write the formula using write cell formula activity in the first cell and then use auto fill range activity to fill the formula in all cells till bottom

Cheers

1 Like
3

The error occured when the excel app scope load the excel & before running its child activities.
(Heavy massive amount of sheets)

Retry scope activity can’t catch this error, this error too amazing!
The error is written as: “job stopped in unexpected bla bla bla~”
While in powerful device, the flow run completely fine.

I can’t use write cell to write formula then autofill it, because:

  1. my formula range is landscape. i know autofill range can handle this, but
  2. autofill range can’t generate landscape excel formula like this isn’t it? (Dynamic sheet name not dynamic cell)
    =‘sheet1’!A1 | =‘sheet2’!A1 | =‘sheet3’!A1
4

@wija

Then better go with writing a macro to update the data…

Cheers

5

Never mind, none can fix this error “job stopped bla bla~” except UiPath do something about this.

This clearly due to excel app scope can’t follow slow excel load performance by weak device. Why i said this?

Because in the end, i rethink hard & revise whole of my project to find all of efficiency that i can think of regarding the project.
The result:

  • 500ish worksheets in my powerful laptop finish in 1hr 6minutes
  • same 500ish worksheets in weaker pc desktop finish in 1hr 2minutes

While before i revise my whole project is:

  • 500ish worksheets in my powerful laptop finish in 1hr 45minutes
  • same 500ish worksheets in weaker pc desktop didn’t make it, when in 4ish hours the error “job stopped bla bla~” occured.
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.