title: Copy and paste cells with python
body: <p>I am trying to copy cells value from one workbook to another. I need to copy cells A1,A2,B4,B5,B6,B7 from Sheet2 and paste into new workbook in cells A1,B1,C1,D1,E1,F1.
  How can I do this with python?  </p>
  
  <pre><code>import xlrd
  file_location = "C:/attach/Source.xlsx"
  workbook = xlrd.open_workbook(file_location)
  sheet = workbook.sheet_by_index(1)
  
  for row in range(sheet.nrows):
      cell = sheet.cell(row, 1)
  print(cell.value)
  </code></pre>