Advertisement
Guest User

My Code

a guest
Jun 24th, 2016
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.60 KB | None | 0 0
  1. import xlwt
  2. import xlrd
  3. import csv
  4.  
  5.  
  6. workbook = xlrd.open_workbook('input.xls')
  7. sheet = workbook.sheet_by_index(2)
  8.  
  9. data = []
  10. data.append([sheet.cell_value(row, 0) for row in range(sheet.nrows)])
  11. data.append([sheet.cell_value(row, 1) for row in range(sheet.nrows)])
  12.  
  13. workbook = xlwt.Workbook()
  14. sheet = workbook.add_sheet('test')
  15.  
  16. for colidx, col in enumerate(data):
  17.     for rowidx, row in enumerate(col):
  18.         sheet.write(rowidx, colidx, row)
  19.  
  20. workbook.save('Commands.xls')
  21.  
  22. with open('file.txt','wb') as fou:
  23.     writer = csv.writer(fou)
  24.     for row in data:
  25.         writer.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement