python 数据写入excel文件

import xlrd
from xlwt import *
from xlutils.copy import copy


xlsfile = r'D:\数据.xls'
open_workbook = xlrd.open_workbook(xlsfile)
open_sheet = copy(open_workbook)
open_ws = open_sheet.get_sheet('Sheet1')

info_list = []

....
....

for i in range(len(info_list)):
    info = info_list[i]
    for j in range(len(info)):
        open_ws.write(i, j, info[j])

open_sheet.save(xlsfile)

# 注意文件地址不要使用打开文件属性后复制文件地址，建议用手写，不然会报错
# save 要在所以存入后在保存，如果写每写入一行就保存，会导致过程很慢