muhammadjazab / auto-team-attandance

My sister is a GR of her class. She had to mark attendance of students from screenshots of teams meeting on an excel sheet. I resolved her problem by reading names from screenshots using PyTesseract and marking them present on the excel using Pandas in Python. It took me 1hr to write the code and it is saving half an hour everyday.

auto-team-attandance

Don't judge the code, this is not the best way to write code. I was learning tkinter that is why GUI is bad.

Here's the Mega link for Downloading exe file

https://mega.nz/file/Go82VDQY#GsCFrPr6-1twJq48YuFvTH0ZNvD9PL2tChznBHsjLe8

How to USE:

1. Download .exe file and run it.
2. Select any excel file. It should have NAME column in it (case sensitive)
3. Select all the cropped screenshots of Attendees (example given)
4. A new file will pop up on your Desktop (Attendees.xlsx)

Orignal Image:

Crop it