Python - Excel信息复制

Question

如何从excel文档的第三个工作表的第一和第二列复制信息

我使用xlwt和xlrd作为库来读取和写入excel文档

这是我的代码:

import xlwt
import xlrd
workbook = xlrd.open_workbook('input.xls')
sheet = workbook.sheet_by_index(2)
data = [sheet.cell_value(row, 0) for row in range(sheet.nrows)]
data = [sheet.cell_value(row, 1) for row in range(sheet.nrows)]
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('test')
for index, value in enumerate(data):
    sheet.write(0, index, value)
workbook.save('Commands')

Answer 1

您正在覆盖data。而不是做:

import xlwt
import xlrd
workbook = xlrd.open_workbook('input.xlsx')
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')

编辑:也写入txt文件使用:

with open('output.txt','wb') as fou:
    writer = csv.writer(fou)
    for row in data:
        writer.writerow(row)