import random
import cv2
import qrcode
import qrcode.image.svg
import numpy as np
from PIL import Image,ImageFont,ImageDraw
import openpyxl
from openpyxl_image_loader import SheetImageLoader
from datetime import datetime,timedelta
from openpyxl import *
import xlsxwriter
pxl_doc = openpyxl.load_workbook('exel.xlsx')
sheet = pxl_doc.active
image_loader = SheetImageLoader(sheet)
i = 0
i1 = 1
while True:
#TC No
excelValue = sheet.cell(i + 2,1).value
excelValue2 = sheet.cell(i + 2,6).value
print(excelValue2)
if excelValue != None:
image = image_loader.get('M{}'.format(i + 2))
image.save('vesikalik.png')

kayitlistesi = xlsxwriter.Workbook( "./kayıtlar/kayitlar.xlsx" )
calismasayfam = kayitlistesi.add_worksheet()
calismasayfam.write(i1,0,excelValue2)
i1 += 1
kayitlistesi.close()
print("tamamlandı!")
elif excelValue == "None":
kayitlistesi.close()
break
else:
break