I have a pdf form with the field names that are the same as my excel spread sheet, how do I make the pdf find the excel file?

Forum|Forum|10 years ago
January 13, 2016
返信数 1.
1757 ビュー

Is there a way to link them together so the pdf will auto fill from the excel file? Also is there a way to fill one field in the pdf with a combination of two fields from the excel file. Example pdf has "name" excel file has "first name" and "last name", I would like to fill name field on the pdf file with a combination of first name and last name from the excel file.

Thanks for any help.

このトピックへの返信は締め切られました。

解決に役立った回答 try67

Thanks, thats what I was doing wrong. Is there an easy way to fill a spot on the form with a combination of 2 fields from the spread sheet?

Thanks again

Using the example above, the custom calculation code for the "name" field will be:

event.value = this.getField("first name").value + " " + this.getField("last name").value;

try67

Community Expert

You can import the data from the Excel file to the PDF, but it's a one time thing and the names of the fields in the PDF and the columns in the Excel file must match EXACTLY. However, you can create hidden fields called "first name" and "last name" and then use a script to populate the "name" field with their combined data, for example.

J

jonv96563430作成者

Participant

I have the part about the field names matching figured out, how do I point to the excel file? There is no import from excel option that I can find in acrobat dc pro

try67

Community Expert

You have to first save the Excel file as a tab-delimited text file. Then in Acrobat go to Tools - Forms - More Form Options (might be called something slightly different in your version) - Import Data. Select the text file you exported from Excel and you're done.

サインアップ

ソーシャルログイン

コミュニティへログイン

ソーシャルログイン

ファイルをウイルススキャンする。

このファイルはダウンロードできません