title: How to Export Large data into Excel
body: <p>I am using <code>sink()</code> function for printing R output to excel/text file. my program output is too large. I found at the end of Excel/text output file a message </p>
  
  <pre><code>[ reached getOption("max.print") -- omitted 5326 rows ] 
  </code></pre>
  
  <p>Also I have more than one large outputs to print. I also want them on separate (different)  sheets of one excel file . </p>
  
  <p>Actually, the output comes in matrix form, as the value of loop increases, the rows and columns of square matrices also increases. the function <code>append</code> does not work due to difference of rows and columns number. to avoid this error I used <code>if</code> condition and deal separately using <code>rbind</code> for similar matrices. But there is more than 5 thousand iteration through double loop (and the method also repeats), so it is impossible to write 1000's of <code>if</code> and <code>rbind</code> conditions and save them into separate sheets and files.</p>