C# 读取Excel文件里面的内容到DataSet

摘要：读取Excel文件里面的内容到DataSet

代码：

/// <summary>
/// 读取Excel文件里面的内容到DataSet
/// </summary>
/// <param name="Path"></param>
/// <param name="ds"></param>
private void ExcelToDS(string Path,ref DataSet ds)
{
    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"";
    OleDbConnection conn = new OleDbConnection(strConn);
    conn.Open();

    //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等  
    DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });

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

    string strExcel = "";
    OleDbDataAdapter myCommand = null;
    strExcel = "select * from [" + strTableNames[0] + "]";//strTableNames[0]取得第一个Sheet中的数据
    myCommand = new OleDbDataAdapter(strExcel, strConn);
    ds = new DataSet();
    myCommand.Fill(ds);
    conn.Close();
    conn.Dispose();
}