Unable to read a cell containing a formula

[Rajdip_Dutta]

Hello all, I am new to this forum.
I am facing an error while trying to copy a cell containing a formula.

The same issue occurs while using the read range.
I am using the read cell and read range under the System>File>Workbook activity.

I am trying to copy I7 and write the value that is =LOWER(C2&“.”&D2&"@zurich.com" in Sheet1

Please help!

PS: I do not want to use excel application scope activities

[William_Blech_Sister]

Hy @Rajdip_Dutta,

Why do you not want to use ‘Excel Application Scope’? This is my first recommendation for you.

Try using the write cell activity inside the scope

Please let me know if it works

Regards

[Rajdip_Dutta]

I have made the entire workflow using System>File>Workbook activities, so I need to change the entire thing. Plus, I would prefer to work on the file without opening it.

Just trying to understand why System>File>Workbook>Read cell won’t work for a cell with a formula. As soon as I replace the formula with a constant term. It works!

Thank you

[William_Blech_Sister]

Hy @Rajdip_Dutta, very gald I could help you

You can use the ‘Excel Application Scope’ without openning the file, just unflag the ‘Open File’ property.

Please like my answer and mark it as a solution, it helps me
Any more questions please let me know

Regards

[Rajdip_Dutta]

Thanks it works just fine!

[William_Blech_Sister]

Very glad I could help you @Rajdip_Dutta happy automation