Python Automation Script for PDF Modification
Budget: ₹1,500 – ₹12,500 INR
I am looking to hire a freelancer who can create a Python-based automation script to modify an existing PDF form (IPO forms) using client details from an Excel sheet. The goal is to overlay the data from the Excel file onto specific fields of the existing IPO PDF template. The form format needs to stay intact, but personalized client data (such as name, address, PAN, bank details, etc.) should be added to the appropriate places in the PDF.
Key Requirements:
1. Programming Language: Python
2. PDF Handling: The script should use libraries such as pypdf2 (or pypdf) and reportlab to open and modify an existing PDF file.
3. Excel Handling: The script should read client data from an Excel file (using openpyxl or pandas).
4. Overlay Functionality: Overlay specific client details from Excel onto predefined areas of the PDF form (e.g., Name, PAN, Address, Bank, etc.).
5. PDF Output: Each client should have a personalized PDF generated by modifying the original form.
6. Accuracy: Ensure precise placement of data in the correct fields on the PDF form based on the image provided.
Additional Notes:
• The original form template is a standard IPO form, and only specific fields need to be updated with client information.
• The script should process multiple entries from the Excel sheet, generating a separate PDF for each client.
Please include any previous experience working on similar PDF manipulation projects and provide an estimated timeline for completion.
Looking forward to working with a talented freelancer!
Key Requirements:
1. Programming Language: Python
2. PDF Handling: The script should use libraries such as pypdf2 (or pypdf) and reportlab to open and modify an existing PDF file.
3. Excel Handling: The script should read client data from an Excel file (using openpyxl or pandas).
4. Overlay Functionality: Overlay specific client details from Excel onto predefined areas of the PDF form (e.g., Name, PAN, Address, Bank, etc.).
5. PDF Output: Each client should have a personalized PDF generated by modifying the original form.
6. Accuracy: Ensure precise placement of data in the correct fields on the PDF form based on the image provided.
Additional Notes:
• The original form template is a standard IPO form, and only specific fields need to be updated with client information.
• The script should process multiple entries from the Excel sheet, generating a separate PDF for each client.
Please include any previous experience working on similar PDF manipulation projects and provide an estimated timeline for completion.
Looking forward to working with a talented freelancer!