title: How can I Add substrings (lines of text) to several excel sheet dataframe outputs?
body: <p>I have 2 DataFrames that I would like add texts to the output excel files (not amend the DataFrames)</p>
  <pre><code>text1 = &quot;This file was generated by Python&quot;
  text2 = &quot;This data was filtered&quot;
  </code></pre>
  <p>This is the code I'm using the generate the excel file with a timestamp:</p>
  <pre><code>TodaysDate = time.strftime(&quot;%d/%m/%Y&quot;)
  now = datetime.datetime.now()
  date = '{}-{}-{}'.format(now.year, now.month, now.day)
  SummaryFile = 'Investor Report for' + date +'.xlsx'
  
  with pd.ExcelWriter(SummaryFile) as writer:  
      df1.to_excel(writer, sheet_name='Summary')
      df2.to_excel(writer, sheet_name='Data used in Summary')
  </code></pre>
  <p>text1 has to be row 1 (before DF1 starts) and text 2 has to be after DF2 ends so I assume <code>len(df2)+1</code> is used to get the position</p>
  <p>Additionally what if you wanted to add 2 rows of substrings? Ex. text1 is row1 and text2 is row2 in the df1 sheet.</p>