title: Python: Writing Images and dataframes to the same excel file
body: <p>I'm creating an excel dashboard and I want to generate an excel workbook that has some dataframes on half of the sheets, and .png files for the other half.  I'm having difficulty writing them to the same file in one go.  Here's what I currently have.  It seems that when I run my for loop, it won't let me add additional worksheets.  Any advice on how I might get my image files added to this workbook?  I can't find anything about why I can't add any more worksheets Thanks!</p>
  
  <pre><code>dfs = dict()
  dfs['AvgVisitsData'] = avgvisits
  dfs['F2FCountsData'] = f2fcounts
  
  writer = pd.ExcelWriter("MyData.xlsx", engine='xlsxwriter')
  for name, df in dfs.items():
      df.to_excel(writer, sheet_name=name, index = False)
  </code></pre>
  
  <p>Then I want to add a couple sheets with some images to the same excel workbook.  Something like this, but where I'm not creating a whole new workbook.</p>
  
  <pre><code>workbook = xlsxwriter.Workbook('MyData.xlsx')
  worksheet = workbook.add_worksheet('image1')
  worksheet.insert_image('A1', 'MemberCollateral.png')
  </code></pre>
  
  <p>Anyone have any tips to work around this? </p>