Text from Excel to PDF via Script

7 replies
2083 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

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.

Translate

Brave_Coast5EAEAuthor

Participant

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

Translate

Book1.txt

try67

Community Expert

In that case you can use the readFileIntoStream method of the util object to read its contents to a Stream object, then the stringFromStream method of the same object to convert it to a String, and then parse it like any other String object in JS to get the info you need from it.

Note that the first method requires a privileged context if you want to specify the file-path of the file to read to it. Otherwise, you'll be prompted to select it manually each time you run the script.

Translate

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!

Translate

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.