- 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];
- }
C#获取Excel里sheet名
最新推荐文章于 2021-06-21 16:22:39 发布