namespace ExcelPOCApps
{
   public class ExcelReader
   {

	 string OledbConnectionString = string.Empty;
	 private OleDbConnection objConn = null;


	 public ExcelReader ( string ExcelFilePath )
	 {
	    OledbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
	    objConn = new OleDbConnection(OledbConnectionString);
	 }

	 public DataTable GetExcelData ()
	 {
	    try
	    {

		  if(objConn.State == ConnectionState.Closed)
		  {
			objConn.Open();
		  }
		  else
			objConn.Open();

		  OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Data$]", objConn);

		  OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

		  objAdapter1.SelectCommand = objCmdSelect;

		  DataSet objDataset1 = new DataSet();

		  objAdapter1.Fill(objDataset1);

		  objConn.Close();

		  return objDataset1.Tables[0];

	    }
	    catch(Exception ex)
	    {
		  objConn.Close();
		  throw ex;
	    }
	 }
   }



}