myFunctions.Fill_Fee_Text(admin_next,ws,f_list_33108[2],f_detail)
myFunctions.Fill_Fee(indx,2,admin_fee_33108,ws)
indx+=1
admin_next=indx
logger.info("Data inserted into file\n")
logger.info("Last_day "+str(last_day))
logger.info("today: "+str(day))
logger.info("Validating last day of month")
if(int(day)==int(last_day)):
logger.info("Creating month end data")
logger.info("checking text file for multiple file entries")
#if file exist enter path to a list
if Path(file_path+"/Email/"+m+".txt").is_file():
path_list.append(file_path+"/Email/"+m+".txt")
#call funcion to fill main page
MainPage.CallMainPage(m,wb,logger) #,file_07_111,file_07_108,file_33_111,file_33_108)
logger.info("Excell file Created and saved.logger file Created as well\n")
wb.save(file_path+'File/'+m+'/'+m+'_'+mYYYY+'.xlsx')
logger.info("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++\n")
logger.info("End of Process")
else:
raise FileExistsError("Sheet already exist with current date as name,please check the excel file\n")
log.info("Sheet already exist with current date as name,please check the excel file")
log=myFunctions.setup_logger('email','test.log')
log.exception("Sheet Already exist with that name")
except Exception as err:
logger.exception(str(err))
except Exception as err:
