Write Cell Excel Formula Issue

I am testing an Excel Automation where I need to write various formulas to cells. See sample image
image

The full Write Cell output is
=IF(ISNA(VLOOKUP(I2,‘C:[O365.xlsx]O365’!$C:$D,2,FALSE))=TRUE,"",
VLOOKUP(I2,‘C:[O365.xlsx]O365’!$C:$D,2,FALSE))

The formula works correctly if entered directly into the cell in Excel and returns the correct value.

However, I get the following Write Cell error when executing in UiPath:-
Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=IF(ISNA(VLOOKUP(I2,‘C:[O365.xlsx]O365Report’!$C:$D,2,FALSE))=TRUE,”,VLOOKUP(I2,‘C:[O365.xlsx]O365Report’!$C:$D,2,FALSE))" has a wrong format;
► Excel is busy;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.

Any ideas please

Hi,

Not sure if it’s just the way it’s been copied/pasted, however the formula in your error text looks like it has a single double quote character between the commas.

=IF(ISNA(VLOOKUP(I2,‘C:[O365.xlsx]O365Report’!$C:$D,2,FALSE))=TRUE,”,VLOOKUP(I2,‘C:[O365.xlsx]O365Report’!$C:$D,2,FALSE))

Hi @gary.cobden ,

Use the formula like below in write cell and try. Thanks.

“=IF(ISNA(VLOOKUP(I2,‘C:[O365.xlsx]O365’!$C:$D,2,FALSE))=TRUE,”+CHR(34)+CHR(34)+",
VLOOKUP(I2,‘C:[O365.xlsx]O365’!$C:$D,2,FALSE))"

@ kirankumar.mahanthi1

Thank you; your solution worked

Much appreciated

your welcome @gary.cobden

please mark solution of my post if you think it helps to resolve your issue. marking solution would help others who are facing the similar issue. thanks for understanding.

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