向一个已知的excel文件里面写入新的数据
from xlutils.copy import copy
import xlrd
def write_append(file_name):
values = ["Ann", "woman", 22, "UK"]
r_xls = xlrd.open_workbook(file_name,formatting_info=True)
r_sheet = r_xls.sheet_by_index(0)
rows = r_sheet.nrows
w_xls = copy(r_xls)
sheet_write = w_xls.get_sheet(0)
for i in range(0, len(values)):
sheet_write.write(rows, i, values[i])
w_xls.save(file_name )
if name == "__main__":
write_append("t1.xls")