C#如何读取Excel

public DataSet ImportFromExcel(string filePath){DataSet ds = new DataSet();string connString = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";DataTable table = OleDbHelper.GetExcelTables(connString);if(table == null || table.Rows.Count <= 0){return null;}foreach(DataRow dr in table.Rows){string cmdText = "select * from [" + dr["TABLE_NAME"].ToString() + "]";DataTable dt = OleDbHelper.FillDataTable(connString, cmdText);dt.TableName = dr["TABLE_NAME"].ToString();ds.Tables.Add(dt);}return ds;}

转载于:https://www.cnblogs.com/ATS-MES/p/3636062.html

相关资源：C#读取Excel源码