How select Excel sheet cell values in any format such as number,text using MVC

See more:

C#

MVC

my excel sheet having four columns. in that first column cells are contains numbers and text.
using the below query to get the values of the particular sheet (excelSheets[0] is having my sheet name)

 OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + excelSheets[0] + "$" + "]", connection);
DataSet main_ds = new DataSet();
da.Fill(main_ds);

Finally that dataset having only the number values and cells having text (abc,def is not coming).


sheet like this

column1
abc
610
764
765
def
123
897
568