Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlwt
- import xlrd
- import csv
- workbook = xlrd.open_workbook('input.xls')
- sheet = workbook.sheet_by_index(2)
- data = []
- data.append([sheet.cell_value(row, 0) for row in range(sheet.nrows)])
- data.append([sheet.cell_value(row, 1) for row in range(sheet.nrows)])
- workbook = xlwt.Workbook()
- sheet = workbook.add_sheet('test')
- for colidx, col in enumerate(data):
- for rowidx, row in enumerate(col):
- sheet.write(rowidx, colidx, row)
- workbook.save('Commands.xls')
- with open('file.txt','wb') as fou:
- writer = csv.writer(fou)
- for row in data:
- writer.writerow(row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement