Assign: Workbook was closed by a 3rd party, while the Excel Application Scope was running

Help
1

Hi All,

I am trying to assign a variable Uploader.ToString to a data row with column header “File Upload by” but I am receiving the following error:
Assign Faulted
Assign: Workbook was closed by a 3rd party, while the Excel Application Scope was running.
Sequence Faulted
image
image

Am I doing something wrong with the assignment?

I am trying to collect variables from different sources and assign them to the appropriate column heading for each row. Is it possible to use the Add Data Row activity and add the variables directly such as {Var1.ToString, Var2.ToString}?

Any assistance would be appreciated.

2

Hi @chend

As far as this question:

Is it possible to use the Add Data Row activity and add the variables directly such as {Var1.ToString, Var2.ToString}

The answer is: yes.

As to the error message, do you think it would be possible for you to mockup and share a new project with minimum amount of activities that will still cause this error? It would make it easier to see it in action :slight_smile:

3

Hi,

Thank you.

I was able to add the variables via ArrayRow. {Var1, Var2, etc…}

1 Like