Adding datas to a column

Heloo guys,

i have values for data1,data2.data3 … upto data8 & i want to add that to total column how can i add that instead of using write cell for each cell

@Gokul_Murali

use a write cell inside for loop

or create a datatable with data you need and use write rnage

cheers

Hi @Gokul_Murali , Where have stored the total values ? is it in another file or calculating on run time and storing to any variable, please confirm.

@Anjani_Kapoor

here i want to add the first value in multiple assign activity in data1, value 2 to data2 respectively

Hi @Gokul_Murali ,

Please check the attached solution xaml and working excel sheet.
Please let me know if this works.

Thank you!
AddDataToColumn.xaml (9.4 KB)
Register.xlsx (9.8 KB)

@Anjani_Kapoor

This file is showing invalid can you send this as a zip file

AddDataToColumn.zip (67.2 KB)s

Please check!

@Anjani_Kapoor

Let me write the steps:

  1. Read excel workbook and fill in “A3” in the range as your table start from A3
  2. use assign activity and assign - RegisterTable(0)(“total”) = “Value1” (mention the value that you want to print for “Value1”
  3. Add 7 more assign activities and assign the values as shown in the screenshot.

Please let me know if this works.

Thank you

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