Write Custom formula in excel

Help Studio
, ,
1

i have an excel , second column values is there , How to convert those values Custom formula by BOT.
Exp–=1068935553.83/10^7

image
image1668×509 24.5 KB

Can Any one help ??

2

@Anand_Designer

Use Read Range activity and output a datatable variable

Now use For Each row activity inside that use Write cell activity

Give you expression as =1068935553.83/10^7, so that will overwrite the expression

Hope this will help you

Thanks

3

its not working , can you give work flow ?

4

@Anand_Designer

Check as below for your reference

image
image1247×363 30.7 KB

Hope this will help you

Thanks

5

It would be much better to update the values in the datatable then just Write Range once to put it into the Excel file. Your loop causes multiple writes to Excel in quick succession, which will probably cause problems especially when there is more data.

1 Like