Read from excel to datatable:How to convert column datatype

Austin Muts10y ago

its not date that i want but a string like string uplift.Unit_Price = DtSet.Tables[0].Rows[i]["Unit Price"].ToString().How can i change this from string to decimal?

Vignesh Mani10y ago

Hi also refer below link. I hope it will usefull

http://www.experts-exchange.com/questions/25020438/How-to-read-a-date-column-in-excel-using-C.html

Vignesh Mani10y ago

Hi Refer below Link

http://stackoverflow.com/questions/9028029/how-to-change-datatype-of-a-datacolumn-in-a-

datatable