title: Python 3x win32com: Copying used cells from worksheets in workbook
body: <p>I have 6 work sheets in my workbook. I want to copy data (all used cells except the header) from 5 worksheets and paste them into the 1st. Snippet of code that applies:</p>
  
  <p>`</p>
  
  <pre><code>excel = win32.gencache.EnsureDispatch('Excel.Application')
  wb = excel.Workbooks.Open(mergedXL)
  wsSIR = wb.Sheets(1)
  sheetList = wb.Sheets
  for ws in sheetList:
          used = ws.UsedRange
          if ws.Name != "1st sheet":
              print ("Copying cells from "+ws.Name)
              used.Copy()
  </code></pre>
  
  <p>`
  used.Copy() will copy ALL used cells, however I don't want the first row from any of the worksheets. I want to be able to copy from each sheet and paste it into the first blank row in the 1st sheet. So when cells from the first sheet (that is NOT the sheet I want to copy to) are pasted in the 1st sheet, they will be pasted starting in A3. Every subsequent paste needs to happen in the first available blank row. I probably haven't done a great job of explaining this, but would love some help. Haven't worked with win32com a ton. </p>
  
  <p>I also have this code from one of my old scripts, but I don't understand exactly how it's copying stuff and how I can modify it to work for me this time around:</p>
  
  <pre><code>ws.Range(ws.Cells(1,1),ws.Cells(ws.UsedRange.Rows.Count,ws.UsedRange.Columns.Count)).Copy()
  wsNew.Paste(wsNew.Cells(wsNew.UsedRange.Rows.Count,1))
  </code></pre>