How can Ｉ write one column to an Excel file

[Dominic]

@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 !

Regards,
Dominic