Read QR code and mark it as green if found in excel file

asked 2019-03-26 04:24:26 -0500

jok23 gravatar image

updated 2019-03-26 09:30:05 -0500

berak gravatar image

I have image that consist of 8 QR codes, like this: image description

I must read all QR codes and for each QR code, I have to look into Excel table and check if QR code is valid. If it is valid I have to mark QR code with GREED else I have to mark it with RED.

Please help with ideas ! It have to be reliable and simple aplication!

edit retag flag offensive close merge delete

Comments

you can use qrcode.cpp but you need to provide better images

sturkmen gravatar imagesturkmen ( 2019-03-26 04:37:47 -0500 )edit

I have to look into Excel table

sorry, but opencv does not handle excel files, you're on your own (at least with the extraction)

berak gravatar imageberak ( 2019-03-26 09:31:42 -0500 )edit

Have you considered using VBScript to control Excel?

sjhalayka gravatar imagesjhalayka ( 2019-03-26 10:46:08 -0500 )edit

If you can save the excel table as csv file, then it is pretty easy to read as a text file.

Chris gravatar imageChris ( 2019-04-15 07:40:10 -0500 )edit