title: Append data into new excel sheet with openpyxl
body: <p>I have bunch of excel workbooks and I would like to get cell values from them and write to a new sheet.</p>
  
  <p>My code is not appending new data.It is just overwriting cells with values from last workbook.</p>
  
  <p>(I've changed the pasted code.It was pasted incorrect.)</p>
  
  <p>Here is my code</p>
  
  <pre><code>from openpyxl import load_workbook
  
  booklist = ["17_02.xlsx", "17_03.xlsx",
          "17_04.xlsx", "17_05.xlsx",
          "17_06.xlsx", "17_08.xlsx",
          "17_09.xlsx", "17_10.xlsx"]
  
  
  for wb in booklist:
      book = load_workbook(filename =wb,data_only=True)
      report = load_workbook(filename="dest.xlsx", data_only=True)
      print(book)
      sheet = book['Sheet']
      reportsheet=report['First']
      row_count=sheet.max_row
      column_count=sheet.max_column
      for r in range(1,row_count+1):
          for c in range(1,column_count+1):
             source=sheet.cell(row=r, column=c)
             dest = reportsheet.cell(row=r, column=c)
             dest.value = source.value
             sheet.title = 'First'
             book.save("dest.xlsx")
  </code></pre>
  
  <p>Edit:</p>
  
  <p>After the mickNeill's answer I changed the code and it worked for appending.But now there is another problem.
  If I run the code (after clearing the cells) second time or more it's appending the data to the rows after the cleared cells.</p>
  
  <p>First run:
  Data appended to A1:A20
  Clear the cells,save and close the workbook.</p>
  
  <p>Second run:
  Data appended to A21:A20 instead of A1:A20 (cleared cells)</p>
  
  <p>Every time I run the code  value of the reportRow continues to increase (1,20,40 ...) and appending data to higher number of rows.</p>
  
  <pre><code>from openpyxl import load_workbook
  
  
  booklist = ["17_02.xlsx", "17_03.xlsx",
      "17_04.xlsx", "17_05.xlsx",
      "17_06.xlsx", "17_08.xlsx",
      "17_09.xlsx", "17_10.xlsx"]
  
  
  for wb in booklist:
      book = load_workbook(filename =wb,data_only=True)
      report = load_workbook(filename="dest.xlsx", data_only=True)
      print(book)
      sheet = book['Sheet']
      reportsheet=report['First']
      row_count=sheet.max_row
      reportRow = reportsheet.max_row
      column_count=sheet.max_column
      for r in range(1,row_count+2):
          for c in range(1,column_count+1):
              source=sheet.cell(row=r, column=c)
              dest = reportsheet.cell(row=reportRow, column=c)
              dest.value = source.value
          reportRow += 1
      report.save("dest.xlsx")
  </code></pre>