TRy this, it will return a data table , from data table you can get all column as required
public DataTable SelectExcelSheet(string strSheetName, string strSheetRange)
{
try
{
if (oleConn == null) Open();
if (oleConn.State != ConnectionState.Open)
return null;
DataTable dataTable = new DataTable(strSheetName);
string SelectQuery = string.Format("SELECT * FROM [{0}${1}]", strSheetName, strSheetRange);
using (OleDbDataAdapter oleAdapter = new OleDbDataAdapter(SelectQuery, oleConn))
{
oleAdapter.FillSchema(dataTable, SchemaType.Source);
oleAdapter.Fill(dataTable);
}
dataTable.Dispose();
return dataTable;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (oleConn != null) Close();
}
}