public static DataSet ExcelToDataSet(string ppfilenameurl,string pptable)

        {

            string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "data source=" + ppfilenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";

            //string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";

            OleDbConnection mmConn = new OleDbConnection(strConn);

            OleDbDataAdapter mmOdda = new OleDbDataAdapter("select * from [sheet1$]", mmConn);

            DataSet mmDs = new DataSet();

            mmOdda.Fill(mmDs, pptable);

            return mmDs;

        }