title: Python copy column data of workbook of named X to another workbook named Y
body: <p>I am in trouble with simple copy of column data of 1 workbook to another workbook's column.</p>
  
  <p>I have work book named data.xls which has a column A filled with 40 000 rows. (A1:A40000). I want its data to be copied to another work book named main.xls. on same location called A1:A40000. I am trying following code.</p>
  
  <pre><code>import xlwt    
  import xlrd
  workbook = xlrd.open_workbook('data.xls')    
  sheet = workbook.sheet_by_index(0)
  i= 0
  a= 40000
  for i in range(0,int(a)): 
      data = [sheet.cell_value(i,0) for col in range(sheet.ncols)]
  workbook = xlwt.Workbook()
  sheet = workbook.add_sheet('test')
  for index, value in enumerate(data):
  sheet.write(i, index, value)
  workbook.save('main.xls')
  </code></pre>
  
  <p>but this code is printing at only 40 000 location rest all are blanks. so i got only 1 data of location A40000.</p>