//动态读取Excel表数据到DataSet
DataSet excelDataSet = new DataSet();
using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BOM.xlsx;Extended Properties='Excel 12.0;IMEX=1';"))
{
con.Open();
DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
using (OleDbCommand cmd = new OleDbCommand("", con))
{
Console.WriteLine("read excel............");
foreach (DataRow item in dt.Rows)
{
string tableName = item["TABLE_NAME"].ToString();
cmd.CommandText = string.Format("select * from [{0}] ", tableName);
DataTable temp = new DataTable(tableName);
temp.Load(cmd.ExecuteReader());
excelDataSet.Tables.Add(temp);
}
Console.WriteLine("read excel done !");
}
}
问题出在Excel中左下角的Sheet1