Assign all of the row in one assign

[omar_ismail]

Hi Team,

I need to get all the cells in the row inside for each row in excel activity in one assign.

[Anil_G (Anil Gorthi)]

@omar_ismail

You can use currentitem.Itemarray..ToArray this will give array of items…

If you need string will all cells concatenated String.Join(",", currentitem.Itemarray..ToArray)

Cheers

[sanjay3 (Sanjay)]

Hi @omar_ismail

For Each Row in DataTable ‘YourDataTable’
Assign ‘rowValues’ = String.Join(" ", row.ItemArray.Select(Function(x) x.ToString()).ToArray())
// ‘rowValues’ now contains all the cell values from the row

Hope this helps

[omar_ismail]

[omar_ismail]

it’s giving me an error

[sanjay3 (Sanjay)]

@omar_ismail
Can share the screenshot of the error

[Shiva_Nikhil]

@omar_ismail

if you are using for each row in datatable use this

string.join(",",currentrow.itemarray.toarray)

[omar_ismail]

I am using for each row in excel

[Anil_G (Anil Gorthi)]

@omar_ismail

I gave the expression to be given inside for each row in datatable

Please change currentrow to whatever each row in datatable is called

cheers

[Anil_G (Anil Gorthi)]

@omar_ismail

please try this

string.join(",",currentrow.DataTableOutValue.Rows(0).itemarray.toarray)

cheers

[Shiva_Nikhil]

@omar_ismail

string.join(",",CurrentRow.Current.tolist)

[omar_ismail]

@Anil_G

string.join(“,”,currentrow.DataTableOutValue.Rows(0).itemarray.toarray)