public DataTable makeExcelTODatatable(string excelName,string sheetName)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data  Source= " + excelName + "; " + "Extended   Properties= 'Excel   8.0;HDR=YES;IMEX=1 '; ";
            string strSql = "select * from [sheet1$]";
            DataSet ds = new DataSet();
            OleDbConnection con = new OleDbConnection(strConn);
            con.Open();
            OleDbDataAdapter oda = new OleDbDataAdapter(strSql, strConn);
            oda.Fill(ds,sheetName);
            con.Close();
            return ds.Tables[sheetName];
            
        }
我到网上找了些回答,但目前还是没解决.忘高人指点.