Write Cell activity resolves in "Read Range: Syntax error."

Help Activities
, ,
1

Hello,

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.

Example:

image
image866×465 21.5 KB

Full sequence:

ExcelBugWriteCell
ExcelBugWriteCell1238×1133 69.2 KB

Files:
Main.xaml (7.3 KB)
Template.xlsx (8.6 KB)
ExcelBugWriteCell.zip (8.7 KB)

3

@Dennis0

Already you placed the Read Range in the top, Why are doing the same again?

Thanks

4

Hi @Dennis0

Please try below things,

Put a delay activity between write cell and read range and set a delay of about 1 or 2 seconds.

And also give range as “” instead of Empty.

Thanks

5

It is only an example that shows the error:

  • Read Range before Write Cell => OK
  • Read Range after Write Cell => Error
6

@Dennis0 have you tried this things?

Thanks

7

Still the same error.
After the Write Cell activity the file is broken and cannot be read by the Read Range activity.

9

Hi @Dennis0 ,

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.

Thanks,
Raluca

10

The Workbook Read Range and Write Range activities are better than using Excel Scope. Try those.

11

Hi @postwick ,

In this case, Read Range is what is causing the error. The correct workaround here is using a scoped activity while we’re fixing the issue.

Thanks,
Raluca

12

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.