How to Read the Data from Excel in C#

Code to read the data from excel :

connExcel = strExcel + strfullpath + ";";

//creating connection objects
_connection = new OleDbConnection(connExcel);
connAccess = new OleDbConnection(strConn);

//creating command object for excel

OleDbCommand cmdExcel = new OleDbCommand();
cmdExcel = _connection.CreateCommand();
cmdExcel.CommandType = CommandType.Text;
cmdExcel.CommandText = "SELECT * from [Sheet1$]";
//Command object for Access
OleDbCommand cmdAccess = new OleDbCommand();
cmdAccess = connAccess.CreateCommand();
cmdAccess.CommandType = CommandType.Text;
cmdAccess.CommandText = "Select * from UtilizationData";
//Dim drAccess As OleDbDataReader = cmdAccess.ExecuteReader()

//Open connections

_connection.Open();
connAccess.Open();

DataSet dsExcel = new DataSet();

daExcel = new OleDbDataAdapter(cmdExcel);
daExcel.Fill(dsExcel, "ExcelTable");

//logic to get file date form the excel file

int colcount = dsExcel.Tables["ExcelTable"].Rows[0].ItemArray.Count;

int rowCount = dsExcel.Tables["ExcelTable"].Rows.Count;
System.DateTime File_Date = default(System.DateTime);

for (iRowCount = 0; iRowCount <= rowCount - 1; iRowCount++)

{
string DateRow = dsExcel.Tables["ExcelTable"].Columns[iRowCount].ToString();
if (Strings.UCase(DateRow).Contains("START DATE")) {
//DateRowindex = iRowCount
File_Date = Strings.Trim(dsExcel.Tables["ExcelTable"].Rows[0][iRowCount].ToString());
break; // TODO: might not be correct. Was : Exit For
}
}