Copy text from Excel and paste it in Pdf copy based on identical filed names

Hello Experts,

I have data in excel and i need to copy the same in Pdf file.

For instance data available in Excel:

Name : Dave
Designation : Controller

The data available in Pdf:

Name :
Designation :

I need to copy Dave and Controller subsequently in pdf copy.

Please let me know if there is any way to do it.

Thanks,
Ganesh
Ganesh VijaykumarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
Just recreate that PDF. Otherwise you need Adobe Acrobat (the licensed version) with the APIs.
0
Ganesh VijaykumarAuthor Commented:
Thanks for the response!

I did not get you "Just recreate the PDF" ??

Okay let me put it across my question again.

I have certain information in an excel sheet eg: Name : Dave and Designation : Controller etc....

I have 3 pdf forms in a folder where you can find Name :.................Designation : ........................

All i have to do is copy data from excel and paste it under the blanks....

Is there any way to do it via VB script or Batch programming or any other way to make this possible....

Thanks for your help in advance!

Ganesh
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Ganesh,

Are the Name and Designation always in the same cell each? For example, the Name is in cell A3 and the Designation is is cell B5. If so, it would be easy to write a script to read the data in those cells using Excel's Component Object Model (COM) calls:
https://msdn.microsoft.com/en-us/library/wss56bz7.aspx

For example, I wrote an EE article that received a comment from a reader  about accessing Excel. This comment has a working example of script code that reads an Excel cell:
http://www.experts-exchange.com/articles/18346/AutoHotkey-Getting-Started.html#c1733937

Then you could place the data extracted from Excel into an FDF file and use PDFtk Server (free!) to fill the PDF form with that data. Specifically, look at the fill_form operation:
https://www.pdflabs.com/docs/pdftk-man-page/#dest-op-fill-form

Regards, Joe
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Ganesh VijaykumarAuthor Commented:
Thanks for the response! I will try doing the same!
0
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Martin,
Thanks for the clean-up and the award — much appreciated! Regards, Joe
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.