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

• Sample 1
• Sample 2
• Sample 3

---

🔰 Note

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