How to add variable values to data table columns

Hi,
I am having difficulty in adding data into data table. I have 3 variables ‘Producers’, ‘Email’ and ‘Telephone’ and I want to store these values in 3 columns in a data table for these 3 values to make one row. Any help will be appreciated.
Thanks

@rameezimtiaz,

Using Add DataRow activity you can achieve this.

Create a datatable with those three columns and use the AddDataRow activity. In that you can pass the parameter values to the table.

1 Like

Hi @rameezimtiaz,

1.Use ADD DATA ROW activity and pass these 3 variables in it and pass the data table in the arguments

Cheers.
Vashisht.

@Vashisht can u give me an example workflow?

I only have values in 3 variables. Add data row works when there is a row present

How many columns are there actually in your excel file?

@rameezimtiaz,

Check this one,

Sequence2.xaml (7.3 KB)

dont have any excel. I have extracted complete text from a website and stored required data in 3 variables. Now i want to add all these variables in data table in 3 different columns so that i can later get all the data in an excel

Hi @rameezimtiaz,

Please check below xaml file i did according to your requirement.

Sheet1 is input and Sheet2 is output…

test.zip (74.7 KB)

Any doubts let me know…

Cheers.
Vashisht.

Thanks brother it worked.

1 Like

Happy to help dude @rameezimtiaz

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