reading data from excel files

Here is code snippet for reading data from excel file

dlls u have to include
Interop.Excel.dll
Interop.Office.dll
Interop.VBIDE.dl
Interop.ExcelAdaptorLib.dll
Microsoft.Office.Tools.Debugger.dll
Office.dll

using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.IO;
here is the code to read excel


string path = "E:\\Users\\PDF\\";
string fileToQuery = "PartyPlannerReport.csv";
string sql = "SELECT * FROM [" + fileToQuery + "]";
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";" + "Extended Properties='text;FMT=Delimited(;);HDR=YES'");
myConnection.Open();
OleDbCommand mycommand = new OleDbCommand(sql, myConnection);
OleDbDataReader dr = mycommand.ExecuteReader(CommandBehavior.CloseConnection);
string pttype = null;
string ptpkg = null;
string sttime = null;
string endtime = null;
string ptTime = null;
string ptno = null;
string ptday = null;
string ptdate = null;
string ptDate = null;
string custfname = null;
string custlname = null;
string custName = null;
string gtname1 = null;
string gtname2 = null;
string gt1age = null;
string gt2age = null;
string gt1gender = null;
string gt2gender = null;
string gt1bc = null;
string gt2bc = null;
//string wphone = null;
string hphone = null;
string cphone = null;
// string arena = null;
while (dr.Read())
{
ptno = dr["Res #"].ToString();
pttype = dr["Party Type"].ToString();
ptpkg = dr["Party Package Name"].ToString();
sttime = dr["Start Time"].ToString();
endtime = dr["End Time"].ToString();
ptTime = sttime.Substring(0, 5) + "-" + endtime.Substring(0, 5);
ptday = dr["Party Day"].ToString();
ptdate = dr["Party Date"].ToString();
ptDate = ptday + "," + ptdate;
custfname = dr["Customer First Name"].ToString();
custlname = dr["Customer Last Name"].ToString();
custName = dr["Customer Full Name"].ToString();
gtname1 = dr["GuestName1"].ToString();
gtname2 = dr["GuestName2"].ToString();
gt1age = dr["GuestAge1"].ToString();
gt2age = dr["GuestAge2"].ToString();
gt1gender = dr["GuestGender1"].ToString();
gt2gender = dr["GuestGender2"].ToString();
gt1bc = dr["GuestBC1"].ToString();
gt2bc = dr["GuestBC2"].ToString();
cphone = dr["Cell Phone"].ToString();
hphone = dr["Home Phone"].ToString();
//arena = dr["Arena A"].ToString();
}
myConnection.Close();