I am trying to write a new column using write cell inside excel scope one by one like this (e1:e5) at a time after each transaction. But it is writing the last transaction’s value only in the new column repeatedly like this (1,1,1,1,1 -e1:e5) @nadim.warsi
@Mareeswar Each time Z value is overwriting to range “c2:c5”.Instead of passing range at once you to increment range by 1 each time.Range should be like below.
“C”+variable.tostring