<注:>默认读取数据从Excel的第二行开始。
1 public DataSet ReadExcel(string Path) 2 { 3 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; 4 OleDbConnection conn = new OleDbConnection(strConn); 5 conn.Open(); 6 string strExcel = ""; 7 OleDbDataAdapter myCommand = null; 8 DataSet ds = null; 9 strExcel="select * from [sheet1$]"; 10 myCommand = new OleDbDataAdapter(strExcel, strConn); 11 ds = new DataSet(); 12 myCommand.Fill(ds,"table1"); 13 return ds; 14 }
对于Excel中的表即sheet([sheet1$])如果不是固定的可以使用下面的方法得到
1 string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; 2 OleDbConnection conn = new OleDbConnection(strConn); 3 DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null); 4 string tableName=schemaTable.Rows[0][2].ToString().Trim();