Closed

Excel to PDF Automation - Javascript or other (for PC)

This script combines multiple PDFs into a single PDF, adds an note to each page, and saves the resulting PDF.

Steps needed for AUTOMATION:

a. Read data from Excel file. Column A = Item#; Column I = ItemType (L=Love; O=Open; F=Failed)

b. Use order of Item# in Column A in Excel file as order to combine PDFs

c. Open the first PDF. Clear any existing data. Add note to the bottom left of the page. Note: This first PDF will be the base PDF that all other files are combined into. note coordinates: 200, 7, 300, 26. Verdana 14 pt. Text color: Red. 2 pt. red stroke on box.

d. Open each subsequent PDF in order from list. For each PDF: Clear any existing note. Add note to PDF and then insert as last page of the first PDF. Close.

e. If possible, add bookmarks and thumbnails for each page.

f. Add page numbers in lower right corner. Coordinates: 820, 19, 848, 31. Verdana 18 pt. Color: Black. No stroke on box.

g. Save the combined PDF as the Excel spreadsheet name + ".pdf"

Note: Each note and page number box will need to have a unique object name. All documents are already in PDF and the script must open each pdf and then place the excel information on the bottom of each page. These are old pdf files and the script will need to pull the name of the file and add the item# at the bottom depending on the code.

Skills: Excel, Javascript, PDF

See more: excel automation pdf, javascript pdf automation, excel pdf javascript, javascript data excel pdf, pdf automation, javascript automation pdf, spreadsheet javascript, spreadsheet in javascript, red or black, red black data, text pdf automation, use existing pdf, text to pdf, script automation, save to excel, save pdf, pdf script, excel to, excel to pdf, excel pdf, excel 7, data base excel, combine excel, color red, c automation

About the Employer:
( 1 review ) Minneapolis, United States

Project ID: #1614930

2 freelancers are bidding on average $45 for this job

mihaiandreicut

hey, I can do your script, please contact me . Have a nice day, Mihai A.

$35 USD in 4 days
(1 Review)
1.0
Manoj3050

Dear sir/madem I'm very intersted in your project.I have good knowledge in PDF creating and Excel. Ready to start right away. PM me back.

$55 USD in 10 days
(0 Reviews)
0.0