title: Adding row data in spreadsheet using pyexcel
body: <p>I'm trying to add row data using <code>pyexcel</code>. In the cookbook I have found a method called <code>update_rows()</code> it takes three arguments (<code>fileToRead</code>, <code>list/dictionary</code>, <code>outputFile</code>)
  I get the following error: <code>NotImplementedError: We do not overwrite files</code></p>
  <p>I can see that this is not the method I'm looking for. I'm open to any module making use of <code>.ods</code> format if it better suits my needs.</p>
  <pre class="lang-py prettyprint-override"><code>import os
  import pyexcel
  import pyexcel.ext.ods
  from pyexcel.cookbook import update_rows
  import datetime
  
  
  def mkExcel(dataList, tDate, pathToFile):
      whereToGo = os.path.join(os.path.expanduser(pathToFile), &quot;Archive_%s.ods&quot;) % tDate
  
      if not os.path.exists(whereToGo):
          dataList = pyexcel.utils.dict_to_array(dataList)
          # &quot;output.xls&quot; &quot;output.xlsx&quot; &quot;output.ods&quot; &quot;output.xlsm&quot;
          dataList = pyexcel.Sheet(dataList)
          print
          dataList
          dataList.save_as(whereToGo)
      else:
          dSheet = pyexcel.load(whereToGo, name_columns_by_row=0)
          dataList = pyexcel.utils.dict_to_array(dataList)
  
          custom_row = {&quot;Row -1&quot;: [11, 12, 13]}
          ## update_rows(existing.ods, custom_row, new.ods)
          update_rows(dSheet, custom_row, whereToGo)
  
  
  now = datetime.datetime.now()
  now = '%s-%s-%s' % (now.year, now.month, now.day)
  
  example_dict = {&quot;Column 1&quot;: [1, 2, 3], &quot;Column 2&quot;: [4, 5, 6], &quot;Column 3&quot;: [7, 8, 9]}
  
  here = os.getcwd()
  mkExcel(example_dict, now, here)
  </code></pre>