How to write list of collection in csv

I have LIST OF COLLECTION in one variable. i want each text in that collection as a column in csv file.
how to write list of collection in csv? when i used write csv activity its need datatable to write into csv.

HI @abhay,

Try to convert the collection in to data table then you can easily update the information into csv.

Other wise using excel application scope you need update the information cell by cell using write cell activity.

how can I convert it into DataTable?

HI @abhay,

Use Build Data Table activity to create a data table.
use foreach activity to loop the collection and use add data row to add those value into data table.

2 Likes