xlWorkBook = xl.Workbook(“out.xlsx”, {‘in_memory’: True})
xlSheet = xlWorkBook.add_worksheet(“Invoice”)
number = 1;
names1 = []
while number == 1:
number += 1;
# namesxl = lis[0]
headerxl = ["No.", "Name", "Rate", "Quantity", "Price", "Total Price:- " + totalPrice.get(), "Time:- "]
numberxl = ["no"]
titlexl = ["Wash & Fold Laundry"]
adressxl = ["SHOP NO. 75 1st FLOOR,PANCHKULA SHOPPING COMPLEX, (PEER MUCHALLA,NEAR SEC.20,PKL."]
# ratexl = lis[1]
# quantityxl = lis[2]
# pricexl = lis[3]
timexl = [t.tm_mday, t.tm_mon, t.tm_year]
col = 0
row = 0
# for row_num, data in enumerate(namesxl):
# xlSheet.write(row, col + 2, namesxl)
# for row_num, data in enumerate(ratexl):
# xlSheet.write(row + 3, col + 3, ratexl)
# for row_num, data in enumerate(quantityxl):
# xlSheet.write(row + 3, col + 4, quantityxl)
# for row_num, data in enumerate(pricexl):
# xlSheet.write(row + 3, col + 5, pricexl)
xlSheet.write(row + 2, col + 7, timexl[0])
xlSheet.write(row + 2, col + 8, timexl[1])
xlSheet.write(row + 2, col + 9, timexl[2])
# xlSheet.write(3, 0, numberxl)
xlSheet.write(row, col + 4, titlexl[0])
xlSheet.write(row + 1, col + 1, adressxl[0])
xlSheet.write(row + 2, col + 1, headerxl[0])
xlSheet.write(row + 2, col + 2, headerxl[1])
xlSheet.write(row + 2, col + 3, headerxl[2])
xlSheet.write(row + 2, col + 4, headerxl[3])
xlSheet.write(row + 2, col + 5, headerxl[4])
xlSheet.write(row + 6, col + 3, headerxl[5])
xlSheet.write(row + 2, col + 6, headerxl[6])
names1 = []
rates1 = []
quantitys1 = []
prices1 = []
for i in menu_category:
for j in order_dict[i].keys():
lis = order_dict[i][j]
print(lis)
# for row_num, data in dict(lis):
names1 = lis[0]
rates1 = lis[1]
quantitys1 = lis[2]
prices1 = lis[3]
# for row_num, data in enumerate(names1):
for row_num, data in cycle(names1):
xlSheet.write(row_num + 3,col+3,data)
for row_num1, data1 in cycle(rates1):
xlSheet.write(row_num1 + 3, col + 3, data1)
for data2 in list(quantitys1):
for row_num2 in data2:
xlSheet.write(row_num2 + 3, col + 4, data2)
for data3 in list(prices1):
for row_num3 in data3:
xlSheet.write(row_num3 + 3, col + 5, data3)
xlWorkBook.close()