使用Excel DataTable导数据：步骤解析与示例

/// <summary>
    /// Excel导入DataTable
    /// </summary>
    /// <param name="strFileName">excel文件路径</param>
    /// <returns></returns>
    public static DataTable ImportToDataTable(string strFileName)
    {
        //根据路径打开一个Excel文件并将数据填充到DataSet中
        string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + strFileName + ";Extended Properties = 'Excel 12.0 Xml;HDR=yes'";
        string strExcel = "";
        strExcel = "select  * from   [sheet1$]";
        OleDbConnection conn = null;
        DataSet ds = new DataSet();
        try
        {
            using (conn = new OleDbConnection(strConn))
            {
                conn.Open();
                OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, strConn);
                adapter.Fill(ds);
                conn.Close();
            }
            return ds.Tables[0];
        }
        catch (Exception)
        {
            throw;
        }
        finally
        {