Read from excel to datatable:How to convert column datatype

Question

I am readind unit price column from excel as oUplifts.sUnit_Price = DtSet.Tables[0].Rows[i][Unit Price].ToString().Trim().How can i convert from string to decimal number?

Austin Mudadi · Answer

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 Mani · Answer

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 Mani · Answer

Hi Refer below Link http://stackoverflow.com/questions/9028029/how-to-change-datatype-of-a-datacolumn-in-a- datatable