How to add Variable values into an existing column of a datatable


I have an excel that has currency conversion datatable .

I wanted to calculate the values of exchange and assign them to a variable - “exchangeValue”.
How can i push “exchangeValue” variable into already existing “exchange” column of datatable.

please help

With write cell activity we can do that
Cheers @Srikavya_n

you can use “exchangeValue” variable in add data row activity and use write range

its in a loop. cannot write write range at once.

but I already have existing rows. I do not want to overwrite them

add Column to Data Table.xaml (7.4 KB)
check this sample!
Cheers @Srikavya_n

i will try this.

i didnt have a clue how to use this code.please check my xaml .Excel Conversion.xaml (24.6 KB)

Excel Conversion.xaml (26.1 KB)

thankyou. this helped me

1 Like

cheers @Srikavya_n

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.