Sort datatable data based on one column

[kumar.varun2 (Varun Kumar)]

Hi @clumsily

Another way to achieve the same.

dt.AsEnumerable.OrderBy(Function (r) r("Brand").ToString).CopyToDataTable.DefaultView.ToTable(False, {"Brand", "Name", "Price"})

Finally you can write dt in excel file using Write Range