I am extracting a few columns from a datatable using dataview and creating a smaller datatable. However, the new datatable is having values instead of text.
code is as follows
DT2 = New DataView(DT1.ToTable(False,DT1.Columns(0).ColumnName, DT1.Columns(1).ColumnName)
these 2 columns are datatype and when I writeRange DT2 to excel I get values for column 1 and 2 instead of Date Text.