This program reads an excel sheet and encodes the data into a qr code with the addition of a unique ID and writes the data back in the excel sheet
Instalation Notes :
Downlaod the .py file
put your excel file In the same directory
Make sure that your excel file is with the extention .xls
to convert xlsx to xls : open your xlsx sheet --> file --> save as --> browse --> save as type : Excel 97-2003 Workbook
Rename your excel sheet to Book1
Make sure that the first column contains the Names and the second column cointains the E-mails , both Without Headings
Run the .py file using any python compiler you like
write the following (one by one) in your python compiler comand prompt
pip install pyimgur
pip install qrcode
pip install xlrd
This program have been tested using Faker package