title: Batch writes in excel using Python PyExcelerate
body: <p>I am trying to speed up the process of writing data to an excel file using python in my code.
  The PyExcelerate module has a good benchmark in terms of writing bulk data to files compared to other python modules.</p>
  
  <ul>
  <li>Dimensions:
  Rows = 10000
  Cols = 50</li>
  <li><p>Times:</p>
  
  <ul>
  <li>pyexcelerate          :  10.11</li>
  <li>xlwt                  :  15.67</li>
  <li>xlsxwriter (optimised):  19.70</li>
  <li>xlsxwriter            :  23.50</li>
  <li>openpyxl   (optimised):  95.82</li>
  <li>openpyxl              :  95.90</li>
  </ul></li>
  </ul>
  
  <p>Also, writing data in batches improves the time taken to write furthermore.
  See link below.</p>
  
  <p><a href="https://stackoverflow.com/questions/4961589/speed-up-writing-to-files[link]">Speed up writing to files</a></p>
  
  <p>Now, what I am trying to do is add data to a list as and when it is computed, and when the list size is equal to 500 or when 500 rows of data have been computed, write to the file.</p>
  
  <p><code>wb = Workbook()
  ws = wb.new_sheet("test")
  ws.range("B2", "C3").value = [[1, 2], [3, 4]]
  wb.save("output.xlsx")</code></p>
  
  <p>Is there a way that we could append the data for 500 rows in a batch?</p>