Python操作excel文件

import xlrd

book = xlrd.open_workbook(filename)

sheet1 = book.sheet_by_index(0)

for row in range(sheet1.nrows):
    for col in range(sheet1.ncols):
        print(sheet1.cell_value(row, col))

import xlwt

wb = xlrd.Workbook()

ws = wb.add_sheet("Sheet1")

ws.write(0,0,"hello")
ws.write(0,1,"world")

wb.save(‘example.xls‘)