for i in invoices: SHIPLIST.append(SHIP) ERpath = 'G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx' EDR = openpyxl.load_workbook(' sheet = EDR.get_sheet_by_name('Register') nextrow = int(sheet.max_row)+1 r=0 while r < len(invoices): for i in SHIPLIST: c = EDR['Register']['B'+str(nextrow)] c.value = int(i) for i in invoices: c = EDR['Register']['K'+str(nextrow)] c.value = int(i) for i in WH: c = EDR['Register']['G'+str(nextrow)] c.value = int(i) r=r+1 nextrow = nextrow + 1 EDR.save('G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx')
AS = [] for i in invoices: AS.append(DMT) EDR = openpyxl.load_workbook( 'G:\\Supply Chain\\Data\\SHIPMENTS\\Electronic Register - SGS - Copy.xlsx') sheet = EDR.get_sheet_by_name('Register') nextrow = int(sheet.max_row) + 1 r = 0 while r < len(invoices): for i in WH: c = EDR['Register']['G' + str(nextrow)] c.value = int(i) r = r + 1 nextrow = nextrow + 1 nextrow = nextrow - (len(invoices)) r = 0 while r < len(invoices): for i in SHIPLIST: c = EDR['Register']['B' + str(nextrow)] c.value = int(i) r = r + 1 nextrow = nextrow + 1 nextrow = nextrow - (len(invoices))