Add Data right next to the column

Hi,

How can I add data to “Adet”? When I try “Add Data Row”, new data isn’t being added right next to “Kalem Nu” and “Malzeme”, rather under them. But I intend to write the data next to them. Thanks in advance. Main.xaml (22.1 KB)

@EmirY

  • for each row activity | row in YourDataTableVar
    • Assign Activity: row(“Adet”) = YourNewValue
1 Like

Hi,

we can use ADD DATA COLUMN ACTIVITY
–where mention the datatable name and column name we want to place the new value
the steps included are
–use a excel application scope and pass the file path as input
–use a read range activity and get the output with a variable of type datatable named outdt
–use add datacolumn activity and mention the above variable as datatable and mention the columnname we want
–now use a for each row loop and pass the above datatable outdt as input
–inside the loop use a assign activity like this
row(“adet”) = yourvalue
–now that value will get added to the new datacolumn

Hi @EmirY

Use write range activity and give range as “C1” and check add headers in property it will write the data from C1, keep the first 2 columns unchanged.

Thanks

Hi, thanks for your help. I’ve figured it out, but with a different method because of my workflow

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