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; } }