i just discovered the following bug:
When using the “Write Cell” activity with an excel sheet that contains a formula in the same row that is written to, the excel file became unreadable with the “Read Range” activity.
When using the “Write Cell” activity in an excel scope, the file remains readable with the “Read Range” activity.
Testet with UiPath Studio 2020.10.10 and UiPath.Excel.Activities 2.10.4.
Thank you for the sample project, I was able to repro this. We’ll look into this but in the meantime, the correct workaround is using the Excel Application Scope.
Put the range as “A1” instead of blank. I had the same issue, this solved it.
If there is an issue with the version of UiPath.Excel.Activities they’re using, they should use a different version not use the less efficient less stable scope activities.