Skip to content

📘 Add names in the certificates using the Python3 and open-cv.

Notifications You must be signed in to change notification settings

Alpha-1729/Name_The_Certificate

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Name The Certificate

📘 Add names in the certificate automatically from excel sheet using Python3.


🔰 Installation

Clone this repository.

git clone https://github.com/Alpha-1729/Name_The_Certificate.git
cd Name_The_Certificate

Installing Dependencies

  • Linux

    You can install all dependencies using the following command in linux terminal.

    sudo pip3 install -r requirements.txt
    
  • Windows

    You can install all dependencies using the following command in command prompt.

    pip install -r requirements.txt
    

🔰Follow These Steps

Step 1

Adding certificate image in the image folder.

  • Add the image of the certificate (jpeg or png) in the certificate folder.
  • Always try to use a jpeg image.
  • Rename it to certificate.jpg or certificate.png.

Step 2

Adding the excel file.

  • Add an excel file containing names into the excel folder.
  • Note the column number of the names in the excel sheet.
  • Note the range of the row in the excel sheet, that contain the names to be printed.
  • i.e. starting index and ending index.

Step 3

Clear the output folder.

  • Remove all images in the output folder.

Step 4

Adding the font.

  • Download the required true type font from the Google Font.
  • Add the font file into the font folder.
  • Sample font is available in the font folder.

🔰Executing the script.

Linux

python3 main.py

Windows

python main.py

🔰Procedure:

Step 1

Selecting the excel, image, font.

  • After executing the script, a dialog box will popup to select excel file, image and font.
  • Select the excel file containing the names. Click here
  • Select the image file of the certificate. Click here
  • Select the font to be used in the certificate. Click here

Step 2

Fill properties in the terminal.

  • A terminal will be opened asking for some values. Click here
  • Add the column number containing names in the excel file.
  • Add the starting index of the row in the excel file.
  • Add the ending index of the row in the excel file.
  • Select the style for name in the certificate.
  • Enter the RGB color code (separate with space) for the name in certificate.

Step 3

Select the region for name.

  • A screen containing the image will pop out. Click here
  • Select the rectangular area where you want to add the name. Click here
  • After selecting the area, press Enter key.

Step 4

Adjusting the font size in the certificate.

  • The longest name in the excel file will the shown in the certificate.Click here
  • Press + key to increase the font-size of the name in the certificate.
  • Press - key to decrease the font-size of the name in the certificate.
  • After fixing the font, press Enter key.

Step 5

Selecting the output folder.

  • New dialog box will appear to select the output folder. Click here
  • Go inside the folder and select the folder. Click here
  • After this, all certificates will be created in the output folder. Click here

🔰 Samples


🔰 Note

  • If any error happens, kindly report the issue.
  • Suggestions are welcome.