public static DataTable GetExcelToTable(string strXlsPath)
        {
            OleDbConnection MyConn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + strXlsPath + ";extended properties='excel 8.0;hdr=false;imex=1'");
            MyConn.Open();

            string strSql = "select * from [Sheet1$]";//";//如果不知道名字就用sheets[1]
            OleDbDataAdapter Adap = new OleDbDataAdapter(strSql, MyConn);
            DataSet ds = new DataSet();
            Adap.Fill(ds, "dt");
            DataTable tb = ds.Tables[0];
            return tb;
        }