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!
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!
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.
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.
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
You'll find scripts and tools here for importing Excel data into Acrobat, but they are not free.