title: Easy way to export multiple data.frame to multiple Excel worksheets
body: <p>I am surprised to find that there is no easy way to export multiple data.frame to multiple worksheets of an Excel file? I tried <strong>xlsx</strong> package, seems it can only write to one sheet (override old sheet); I also tried <strong>WriteXLS</strong> package, but it gives me error all the time...</p>
  
  <p>My code structure is like this: by design, for each iteration, the output dataframe (tempTable) and the sheetName (sn) got updated and exported into one tab. </p>
  
  <pre><code>for (i in 2 : ncol(code)){ 
          ...
          tempTable &lt;- ...
          sn &lt;- ...
          WriteXLS("tempTable", ExcelFileName = "C:/R_code/../file.xlsx",
                SheetNames = sn);
  }
  </code></pre>
  
  <p>I can export to several cvs files, but there has to be an easy way to do that in Excel, right?</p>