将excel文件导入到dataset中

/// <summary>
    /// 将excel文件导入到dataset中
    /// </summary>
    /// <param name="fileName">文件路径</param>
    private void ImportXlsToData(string fileName)
    {
        string str= "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
        string oledbstr = "select * from [Sheet1$]";
        OleDbConnection conn = new OleDbConnection(str);
        try
        {
            conn.Open();
            OleDbCommand com = new OleDbCommand(oledbstr, conn);
            OleDbDataAdapter adp = new OleDbDataAdapter(com);
            DataSet ds = new DataSet();
            adp.Fill(ds);
        }
        catch (Exception err)
        {
            //显示错误信息
        }
        finally
        {
            conn.Close();
        }
    }