Пример #1
0
def log_claim_file_counts(loadfilecount,claimcount,xz_fn,xz_dt):
    rec_log_fn = '837 RIC Receipt Log.xls'
    rec_log = os.path.join(reclogpath,rec_log_fn)
    rec_log_o = Xls(rec_log)
    wksht = 'Sent ' + xz_dt.strftime('%Y-%m')
    try:
        rec_log_o.xls.ActiveWorkbook.Worksheets(wksht).Activate()
    except:
        # create new worksheet
        rec_log_o.xls.Worksheets.Add()
        rec_log_o.xls.ActiveSheet.Name = wksht
        headers = ['Date','File Count','Claim Count','File Name']
        rec_log_o.load_headers(headers)
    blank_row = rec_log_o.find_first_blank_row()
    loadvals = [xz_dt.strftime('%m/%d/%Y'),loadfilecount,claimcount,xz_fn]
    for i,lv in enumerate(loadvals):
        rec_log_o.loadvalue(lv,blank_row,i+1)
    rec_log_o.saveclosequit()
    return None