asp.net 读取Excel文档

<注：>默认读取数据从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();

 

 

posted @ 2014-04-23 20:34  追逐者——Eagle  阅读(190)  评论(0)  编辑  收藏  举报