Create function report(userdate_date, userpath) and call inside main function. try this. (I have not made any change in code).
Create your function
def dpr(request): if request.method == 'POST': userdate_date = request.POST.get('num1') userpath = request.POST.get('num2') if userdate_date and userpath: report(userdate_date, userpath) return render(request,'dpr.html') def report(userdate_date, userpath): # userdate_date = request.POST.get('num1') ## No need # userpath = request.POST.get('num2') ## No need # add = f'your num is {num1} and {num2} path = r'\\10.9.32.2\adm\Ash\FY 2019-20\Sale detail sheet' userpath1 = f'SALE DETAIL SHEET {userpath.upper()} 2020' abc = os.path.join(path, userpath1+'.xlsx') customers1 = [20,31,28,27,17,46,18,13,15,14,37,100125] customers2 = [100051,100062,100072,100087,100071,100070] customers3 = [100057,100056,100066,100068,100086,100091,100103,100126,100131,100145,100150,100152,100140,100165,100180] x = datetime.datetime.now() month = x.strftime("%B") df = pd.read_excel(open(abc, "rb"), sheet_name= month.upper() ,index_col=None, header= None) tarik = userdate_date # program for sumifs and countifs for customers1 and appending data to Dpr sum_list1 = [] count_list1 =[] for i in customers1: ab = df[df[2] == i] a= (ab[ab[6]== tarik][8]).sum() b= (ab[ab[6]== tarik][8]).count() sum_list1.append(round(a,2)) count_list1.append(b) app = xlwings.App(visible=False) wb = app.books.open(r'\\10.9.32.2\adm\Ash\FY 2019-20\DAILY REPORT\DAILY REPORT FORMAT.xlsx') # wb = xlwings.Book(r'\\10.9.32.2\adm\Ash\FY 2019-20\DAILY REPORT\DAILY REPORT FORMAT.xlsx') # xlwings.App().visible=False ws = wb.sheets['DPR'] ws.range('E7').options(transpose=True).value = count_list1 ws.range('F7').options(transpose=True).value = sum_list1 # program for sumifs and countifs for customers2 and appending data to Dpr sum_list2 = [] count_list2 =[] for i in customers2: ab = df[df[2] == i] a= (ab[ab[6]== tarik][8]).sum() b= (ab[ab[6]== tarik][8]).count() sum_list2.append(round(a,2)) count_list2.append(b) ws.range('E20').options(transpose=True).value = count_list2 ws.range('F20').options(transpose=True).value = sum_list2 # program for sumifs and countifs for customers3 and appending data to Dpr sum_list3 = [] count_list3 =[] for i in customers3: ab = df[df[2] == i] a= (ab[ab[6]== tarik][8]).sum() b= (ab[ab[6]== tarik][8]).count() sum_list3.append(round(a,2)) count_list3.append(b) ws.range('F27').options(transpose=True).value = sum_list3 ws.range('E27').options(transpose=True).value = count_list3 # print(sum_list3) # print(count_list3) dict1= { 'F7' : 'E49', 'F8' : 'E50', 'F9' : 'E51', 'F10' : 'E52', 'F11' : 'E53', 'F12' : 'E54', 'F13' : 'E55', 'F14' : 'E56', 'F15' : 'E57', 'F16' : 'E58', 'F17' : 'E59', 'F18' : 'E60', } for i,j in dict1.items(): num1 = 0 num1_new = ws.range(i).value num2 = ws.range(j).value ws.range(j).value = (num2+(num1_new - num1)) dict2= { 'F20' : 'E62', 'F21' : 'E63', 'F22' : 'E64', 'F23' : 'E65', 'F24' : 'E66', 'F25' : 'E67', } for i,j in dict2.items(): num1 = 0 num1_new = ws.range(i).value num2 = ws.range(j).value ws.range(j).value = (num2+(num1_new - num1)) dict3= { 'F27' : 'E69', 'F28' : 'E70', 'F29' : 'E71', 'F30': 'E72', 'F31' : 'E73', 'F32' : 'E74', 'F33' : 'E76', ## 'F34' : 'E77', 'F35' : 'E78', 'F36' : 'E79', 'F37' : 'E80', 'F38' : 'E81', 'F39' : 'E82', 'F40' : 'E83', 'F41' : 'E84', } for i,j in dict3.items(): num1 = 0 num1_new = ws.range(i).value num2 = ws.range(j).value ws.range(j).value = (num2+(num1_new - num1)) wb.save() wb.close() Use the function
def dpr(request): if request.method == 'POST': userdate_date = request.POST.get('num1') userpath = request.POST.get('num2') if userdate_date and userpath: report(userdate_date, userpath) return render(request,'dpr.html')