Text from Excel to PDF via Script

Forum|Forum|3 years ago
August 13, 2022
2 replies
2052 views

Dear All,

is it possible to add text automatically to a pdf from a excel worksheet?

In this case, i would like to add "XCKA-1P" to the PDF.

Thanks in advance!

PDF:

And Excel:

Acrobat SDK and JavaScript

This topic has been closed for replies.

try67

Community Expert

A script can't read data from an Excel file. It might be able to do it if the file was saved as a plain-text file, though.

Brave_Coast5EAEAuthor

Participant

yes, the excel file can easily be converted to text.

Book1.txt

Brave_Coast5EAEAuthor

Participant

sounds good. but is there any help on how to do this? i now how to do VBA macros in Excel but in Acrobat i have really no idea

i am attaching all files, as well as an example (jpg)

Book1.txt

Seiten_extrahieren_15-8.pdf

Brave_Coast5EAEAuthor

Participant

A script would have to find the name on each PDF page, compare it to the XLS Column A, and then add a text field to the PDF Page with the according data from column C.

In the example, the PDF page with the name "Ute Schmidt" would get a text field with "XCKA-1P"

The PDF page with "Gitta Lippold" would get a text field with "GBAD-1K"

and so on.

The text field can be anywhere on the PDF file in a free area.

Lastly the script should save and close the PDF file.

Again, thank you!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded