Problem triggering Excel formula with a write cell activity

[Geoffroy_Pantegnies]

Hello everyone,

I have some trouble with Excel, and I was hopping to find a solution here

When I write with workbook write cell activity a value in Excel, I’m expecting a formula to be triggered as we can see in the line 4.

But when the robot write it in D2, it is not triggering them.

In order to make it work I have to click on the signal and click ‘Convert to number’.

So I tried in my workflow to convert to double / integer before writing it but it makes no difference.

If anyone have an idea I’d be glad to hear it

Have a nice day !

[Denzil_Bangera]

Hi,

Hope this is related to your issue.

How to convert excel cells in uipath from string to number

When I check the values on the excel says it says “it is formatter as text” and makes the computations error , I don’t want to convert it to number one by one by clicking convert to number. Is there a way to automatically convert values from cells into numbers ? For example I wanna convert all values from cell E24:E45. Thank you for any idea.

[Geoffroy_Pantegnies]

Hello Denzil,
Thanks for answering !
I tried to convert to double but it does not solve the issue. In the Excel it’s still considered as text.

As a solution I’ve find a way to force the format in the Excel formula instead.

Have a nice day