C#读取excel文件内容

实测能用，需要的可以试一下，哪里不会，欢迎私信！ 

        public void readExcel(string excelPath){OleDbConnection olecon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +excelPath + ";Extended Properties=Excel 8.0");//excelPath:待读文件路径OleDbDataAdapter oledbda = new OleDbDataAdapter("select * from [" + "Sheet1" + "$]", olecon);//Sheet1表名称DataSet myds = new DataSet();oledbda.Fill(myds);string P_str_Content = "";//存储读取到的内容for (int i = 0; i < myds.Tables[0].Rows.Count; i++){for (int j = 0; j < myds.Tables[0].Columns.Count; j++){P_str_Content += myds.Tables[0].Rows[i][j].ToString();}P_str_Content += Environment.NewLine;}}