xlutils.copy

# -*- coding: utf-8 -*-

import os

from xlutils.copy import copy

import xlrd as ExcelRead

defwrite_append(file_name):

values=["Ann","woman",22,"UK"]

r_xls=ExcelRead.open_workbook(file_name)

r_sheet=r_xls.sheet_by_index(0)

rows=r_sheet.nrows

w_xls=copy(r_xls)

sheet_write=w_xls.get_sheet(0)

foriinrange(0,len(values)):

sheet_write.write(rows, i, values[i])

w_xls.save(file_name+'.out'+os.path.splitext(file_name)[-1]);

if__name__=="__main__":

write_append("./test_append.xls")

追写前

name sex  age country

jim  man  19 USA

hmm  woman 24 CHN

lilei man  24 CHN

追写后

name  sex  age country

jim  man  19 USA

hmm  woman 24 CHN

lilei man  24 CHN

Ann  woman 22 UK