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