Refresh Excel Data Connections error - Value cannot be null (Parameter 'Create in workbook')

Help Activities
, ,
1

I have started receiving this error with UiPath.Excel.Activities v2.23.1-preview and v2.23.2-preview.

I do not receive the error with UiPath.Excel.Activities v2.23.0-preview.

Is anyone able to use this activity with v2.23.1-preview or v2.23.2-preview? Has something changed about the activity or is it a bug?

Successfully run with v2.23.0-preview:

image
image583×572 14.6 KB

Error message in same project with v2.23.2-preview:

image
image583×570 16.2 KB

image

I haven’t changed anything in the above runs other than the UiPath.Excel.Activities version.

2

@KevinE

  1. Those are preview versions so there can be something breaking in them
  2. Did you try by adding a new excel scope instead of retaining same…does the error persist?
  3. Also to confirm check in locals panel if excel variable is becoming null by any chance…

Cheers

3

@Anil_G is the activity working for you in v2.23.1-preview or v2.23.2-preview?

4

I’ve come to the conclusion, after many hours of debugging that the versions above v2.23.0-preview are faulty and cause the error: " Refresh Excel Data Connections error - Value cannot be null"