How can i write excel with data array

[thangapandian (THANGAPANDIAN M)]

I am having some data in data array variable “system.data.datarow” how can i write this data into excel file

[Dominic]

@thangapandian, convert it to a data table

DataRow[*].CopyToDatatable

Regards,
Dominic

[thangapandian (THANGAPANDIAN M)]

thank you

[siahVudu (siyamthanda)]

Hi @Dominic,

my problem is that I have a DataTable which contains all the data in excel sheet so I want to convert it to DataRow[], is this possible?Please help

[balupad14 (Balamurugan)]

HI @siahVudu,
you can use like “dtTable.Select()” . It will return the datarow array.

Regards
Balamurugan

[siahVudu (siyamthanda)]

Thank you so much for quick reply,it worked:slightly_smiling_face:

[Dominic]

Alongwith balu’s solution, dt.AsEnumerable() can also be used.

Edit: Remember that above will return System.Data.EnumerbaleRowCollection(of System.Data.DataRow). .ToArray is essential to be converted into Datarow array

[siahVudu (siyamthanda)]

@Dominic,Thank you that also works

[SagarSB]

exactly how to implement it.
I am using assign activity.
@Dominic