How can I write one column to an Excel file


How can I write one column from a datatable which has some columns to an Excel file .
Like this picture.xlsx (43.6 KB)


@oitot, directly use this query in write range, if you want distinct elements from that column
datatable.DefaultView.ToTable(True,“Column Name”)

If you want all values (including duplicate) make that true to false !

Dominic :slight_smile:

I need to retrirve the unique countries names from data and store it in some variable?

@oitot Refer this workflow
writeColumn.xaml (7.9 KB)


HI Dominic
I used “datatable.DefaultView.ToTable(False,“Column Name”)”. It worked !
Thanks so mush!!!


Hi Bharat.
Thanks ,it worked !