PDF Form Creation from Excel Data

Introducing the PDF Form Creation tool, a Python project designed to generate individual PDF forms from Excel data. Each row in your spreadsheet corresponds to a unique PDF file, streamlining the process of creating customized forms.

Features:

1 Excel to PDF Form: Converts Excel data into individual PDF forms.

2 Automation: Each row in the Excel sheet results in a separate, filled PDF file.

3 Python-Powered: Developed using Python for flexibility and ease of use.

The employee's data will be in Excel format:

All employee information should be on one raw

The pdf form template:

Fields should be created using Adobe DC, and the field names should match the Excel column names, see below for more details

The files in the output folder

Each raw from excel file generates one PDF file

The file after filling will be look like

How to Start?

1 Change the variables names

variables that need to change when you have a new data report are:

• rawDataFile_filename --> This variable holds the input Excel file of row data, and this file in the directory should be in the subfolder in the main code folder --> usually in the "In" subfolder.
• pdf_template --> This variable holds the pdf template file, and this file in the directory should be in the subfolder in the main code folder --> usually in the "In" subfolder.
• pdf_outPut_path --> this variable holds the output folder --> usually is "Out" subfolder.
• outPutFileName --> This variable holds the output file name, change it as you like

2 Check the Dictionary variable

• dictionary --> This dictionary holds all variable's names from the pdf form and the values from the Excel file, it will be filled automatically, but
• If you have a field name that is not the same as the column name in the Excel file, you should add it manually, otherwise, the code will not work.
• see dictionary value to know how to add manually.

3 Make the fields in the PDF

• You should use a tool called 'Prepare Form' in Adobe Acrobat Pro DC.
• Important: Before start adding fields, make sure to delete all auto-created fields in the form, you can look on the field panel at the right to see all the fields that exist.
• Use the 'Add a text filed' option, not 'Add text', Then assign the fields places.
• Be sure that the field name is exactly as the column name in Excel file
• Also, any font format can be made while making the field.

❗ This is very important

No field name duplication allowed: if you duplicate any filed name it will not be filled (at least in my code)