Encerrado

Script to generate pdf documents based on excel file

The goal of this script will be, based the an excel file, to generate PDF documents respecting a specific format. Every line of the excel file represents data from a single client. Our goal is to generate personalized letters according to his name, etc.

1) Input : Excel file containing containing 3 columns as following:

a. Column 1 : Name

b. Column 2 : Last Name

c. Column 3 : City

Logic: For each line of the excel file generate a PDF page. All PDF pages are in the same PDF Document.

We have 2 scripts, one generating the pdf for the all certificates and one generating the pdf for all letters. When certificate script is done we need just to extend the position_of_the_text input file to create the letter.

a. Certificate:

Set the font to : Normal font at the moment

Set the color to: Black colour at the moment

Set the size to: According to the [login to view URL] sent

Set the page to: A4, horizontal

Set the position of the text: According to the [login to view URL] sent ( Try to be close to the pdf sent). Format of the Position of the text is provided below more in detail

Position of the text - should be an input file(txt or excel) with the following format:

1. Name & Last Name, Line X, Position Y

2. “2020”, Line X, Position Y

Comments:

- Name & Last Name means that we are going to use only these fields from the excel file)

- Positions will help us find the exact spot we want the text to be in in case we have different printers etc.

- Position of the text file should be parametric in order to be extended and to be used for the Letter & Folder below.

- You need to try to estimate the original position of the pdf with just text that I will send you. We will be able to change the input file “Position of the text” according to our needs so don’t worry if it’s not perfect according to the pdf sent.

b. Letter

Set the font to : Normal font at the moment

Set the color to: Black colour at the moment

Set the size to: According to the [login to view URL] sent

Set the page to: A4, vertical

Set the position of the text: According to the [login to view URL] sent ( Try to be close to the pdf sent). Format of the Position of the text is provided below more in detail

Same as certificate but now we use as input different text:

Position of the text:

1. Name , Line X, Position Y

2. City , Line X, Position Y

3. Name , Line X, Position Y

4. Name , Line X, Position Y

5. Name , Line X, Position Y

Habilidades: Python, Java, PDF, Processamento de dados

Veja mais: convert excel file pdf, perl script generate pdf documents, create calculator based excel file web, convert multiple excel files to pdf vba, vba code to save excel file as pdf, excel macro save as pdf with date in filename, excel save as pdf filename based on cell value, macro to save pdf in specific folder, convert excel sheet to pdf using vba, excel macro save as pdf filename from cell, excel macro create pdf, html script generate pdf, excel file lock fields, generate class java based xml file, create automatic emails outlook based excel file, excel file locked fields, script generate pdf, php script generate pdf, imacro search based excel file, script generate excel file php

Acerca do Empregador:
( 1 comentário ) KORYDALLOS, Greece

ID do Projeto: #27912925

12 freelancers estão ofertando em média €24 nesse trabalho

IshaqKN

Hi there, Yes sure. I've done similar task before. We don't need positions in x,y - I can align text, e.g. left, right, center. I don't see any attachment. Great exp working with PDFs. I could be the best candidate! Mais

€40 EUR em 1 dia
(55 Comentários)
5.2
brashel

Hi dear, I understand your task and able to make a sheet using pdf. So, please contact me. Thanks a lot.

€15 EUR em 1 dia
(39 Comentários)
5.0
woshiang717

Hi! I am happy to put my bid on here. I have read your requirement carefully and I am interested in this project. I have a tons of experience in Java and Python. If you`ll hope to work with me, I am confident to provi Mais

€30 EUR em 1 dia
(3 Comentários)
1.9
cinardoruk

Hello, I can make Python scripts that'll generate the certificates and letters you need, using data from excel sheets. Kind regards, Cinar Doruk

€19 EUR in 3 dias
(1 Comentário)
2.0
chnsci

Greetings, I think here you are looking for someone to generate PDF documents respecting a specific format. I understood your project description. I am an expert in Python, Data Processing, PDF and I am really inte Mais

€20 EUR in 2 dias
(3 Comentários)
1.8
jatwal2054

I have read the project requirement. I can write a python script for creating the certificates and letters using python library(FPDF). We can discuss the rest in chat.

€8 EUR in 3 dias
(1 Comentário)
1.3
Jsharma4

Dear Employe, I am new on freelancer Thar's why my price is extremely low I would like to be allowed to do the job for you. I have read the details on the job requirements and I am willing to deliver you quality work Mais

€15 EUR in 4 dias
(0 Comentários)
0.0
Soufelhanafi

Hello! I'm a software engineer with more than 3 years of experience, I can do this job for you using python or java as you like, please contact me to discuss more your job. thanks

€50 EUR in 7 dias
(0 Comentários)
0.0
ajayvictor

I have exactly worked on a similar project and if you can ping me via chat I can even show you the thing that which I already worked on.. I understand your requirement perfectly and I can deliver this quickly. 4+ years Mais

€19 EUR in 7 dias
(0 Comentários)
0.0
ronthejohnson

DONE LESS THAN 1 DAY! Let me help you with that 2 scripts, sir. I make sure you won't get anything but 100% satisfaction! Hi, As you see, I'm new to this Freelancer Platform, which means I will do anything... YES AN Mais

€10 EUR em 1 dia
(0 Comentários)
0.0
reviewofplan

Hello, I read your job Description and I can Work on your Project and complete Operation perfectly, you will get satisfactory results. I have Skills in MS Excel, Virtual Assistant, Web Search, Data Processing, Data Ent Mais

€30 EUR in 9 dias
(0 Comentários)
0.0
Nurishamirazak

γεια/hello. I hope you have a good day today. First, let me introduce myself. I am Ishamira from Malaysia. I have lots of experience and knowledge in data entry since I have studied in this field for about more than 3 Mais

€26 EUR in 3 dias
(0 Comentários)
0.0