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

Help
1

Hello,

I have an excel that has currency conversion datatable .

Screenshot (3)
Screenshot (3)1366×768 88.9 KB

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

2

With write cell activity we can do that
Cheers @Srikavya_n

3

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

4

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

5

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

6

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

7

i will try this.

8

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

9

Excel Conversion.xaml (26.1 KB)
cheers!

10

thankyou. this helped me

1 Like
11

cheers @Srikavya_n

12

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