/// <summary>
/// 根據(jù)excel的文件的路徑提取其中表的數(shù)據(jù)
/// </summary>
/// <param name="Path">Excel文件的路徑</param>
private void GetDataFromExcelWithAppointSheetName(string Path)
{
//連接串
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);

conn.Open();

//返回Excel的架構(gòu)，包括各個sheet表的名稱,類型，創(chuàng)建時間和修改時間等
DataTable dtSheetName = conn. GetOleDbSchemaTable (OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });

//包含excel中表名的字符串數(shù)組
string[] strTableNames = new string[dtSheetName.Rows.Count];
for (int k = 0; k < dtSheetName.Rows.Count; k++)
{
strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
}

OleDbDataAdapter myCommand = null;
DataTable dt = new DataTable();

//從指定的表明查詢數(shù)據(jù),可先把所有表明列出來供用戶選擇
string strExcel = "select * from [" + strTableNames[0] + "]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new DataTable();
myCommand.Fill(dt);

dataGridView1.DataSource = dt; //綁定到界面
}