How to properly add formula in the Excel Output I've created?

Help Studio
, ,
1

Image

I wanted to add formula in a specific Cell Range; the formula is “=IF(AD2=“COLOR”,I2,”“)”, but error encountered as you can see in the image. I tried to change it into “=IF(AD2=‘COLOR’,I2,’ ')”; this doesn’t have error in Studio but the excel output is corrupted due to wrong formula.

Also encountered this: “The process cannot access the file because it is being used by another process in UiPath”; obviously because I am accessing the same output file. Is there a way to close the process/ excel before executing the write cell?

2

Hi,

For now can you try the following?

"=IF(AD2=""COLOR"",I2,"""")"

Also encountered this: “The process cannot access the file because it is being used by another process in UiPath”; obviously because I am accessing the same output file. Is there a way to close the process/ excel before executing the write cell?

If you use ExcelApplicationScope or Use ExcelFile , please use not System-FileWorkbook-WriteRange but ExcelWriteRange in AppIntegration.

Regards,

1 Like
3

Thank you, Yoichi - San. It’s now working :slight_smile:

4

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