`
sohighthesky
  • 浏览: 36337 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
最新评论

C#获取Excel里sheet名,其表内容

    博客分类:
  • C#
阅读更多
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];
}
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics