title: Export multiple dataframes to one Excel Sheet with r
body: <p>I have around 30 different data frames in r and I want them to be in one Excel sheet, with the dataframe name as well. </p>
  
  <p>For output I'm looking for something like this:</p>
  
  <pre><code>dfname1
  col1    col2
    x        x
    x        x
  dfname2
  col1    col3
    x        x
  </code></pre>
  
  <p>How should I do this as an iterative process?</p>