Not writing in proper format in excel

Help Activities
, ,
1

Hello everyone,
I am writing values from one Excel file to another excel file using read and write but i don’t some cells writing properly, showing as ########. below snippet shows that, I am writing from B6 - L6 but some values are not writing properly.

image
image1875×125 6.35 KB

2

@MICHKEL_ANGLO_J

  1. In read check if display value is selected if so change to raw value
  2. You can directly use copy paste range as well

Cheers

3

i can’t use copy paste range, as it comes with ui automation to extract values from outside file and dynamically write cells. But now problems solved, by using format cell features.

but now i am getting error in applying formula by using write cell activity.
“=IFERROR(IF((D6/C7)>1,1,(D6/C7)),”“)”. even used that in double quotes. throwing error.
suggesting me this too : If your data is a formula, make sure you use comma as parameters separator;

4

Escape the double quotes using extra double wuotes like " as ""

Also copy paste ramge is an excel activity and not ui

Cheers