获得Excel里的内容

public static DataTable GetExcelTable(string excelFilename)  
{  
    string connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Engine Type=35;Extended Properties=Excel 8.0;Persist Security Info=False",excelFilename);  
    DataSet ds = new DataSet();  
    string tableName;  
    using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(connectionString))  
    {  
        connection.Open();  
        DataTable table = connection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);  
        tableName = table.Rows[0]["Table_Name"].ToString();  
        string strExcel = "select * from " + "[" + tableName + "]";  
        OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, connectionString);  
        adapter.Fill(ds, tableName);  
        connection.Close();  
    }  
    return ds.Tables[tableName];  
}

 

posted @ 2014-07-02 11:41  呼啦啦bear  阅读(203)  评论(0)    收藏  举报