python 向已有的xls中添加值

import os

import xlrd,xlwt
from xlrd import open_workbook
from xlutils.copy import copy

def output_xls(xlsname,str1,str2,str3,str4,readtime):
    os.chdir(Mailfile_Path)
    if os.path.exists(os.path.join(Mailfile_Path,xlsname)):
        # 添加记录
        rownum = get_rowsnum(xlsname)
        oldwb = xlrd.open_workbook(xlsname,formatting_info=True)
        newwb = copy(oldwb)
        newsheet = newwb.get_sheet(0)
        templist = [readtime,str1,str2,str3,str4]
        writesheetrow(newsheet,templist,rownum,False)
        newwb.save(xlsname)
    else:
        # 新建xls
        xlsfile = unicode(xlsname,"utf8")
        wbk = xlwt.Workbook()
        sheet = wbk.add_sheet('avi_sum',cell_overwrite_ok=True)
        first_col = sheet.col(0)
        first_col.width = 256*18
        sec_col = sheet.col(1)
        sec_col.width = 256*8
        thi_col = sheet.col(2)
        thi_col.width = 256*8
        for_col = sheet.col(3)
        for_col.width = 256*10
        fif_col = sheet.col(4)
        fif_col.width = 256*15
        headlist = ['Date','Lotid','Waferid','Productid','Ink_die_count']
        writesheetrow(sheet,headlist,0,True)
        templist = [readtime,str1,str2,str3,str4]
        writesheetrow(sheet,templist,1,False)
        wbk.save(xlsfile)

    参考：https://www.crifan.com/python_append_new_data_into_existing_excel_xls_file/