Is it possible to convert Object[] to datarow?

Help Studio
, , ,
1

Hi All,

I am reading single row from gsheet using read row activity(return type_ object , i want convert to datarow how?

Thank you.

2

@tsurampudi Try below one

  • Take build data table
  • After you retrieve row from the gsheet
  • Take data row activity and pass the retrieved value
3

Sorry, that is not my requriment. i need pick each row form excel or gsheet.

4

Yes, it’s possible. Please follow this and let me know if it works for you: c# - How can I manually / programmatically create a DataRow? - Stack Overflow

You can use the Assign activity to initialize a new datatable. Loop through your object array using a For Each, and replicate the lines provided in the stackoverflow example.