These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Allow data from another app (e.g. Excel) to be copy/paste into a form

Forum Index > Forms: Acrobat > Allow data from another app (e.g. Excel) to be copy/paste into a form
2009-03-26 09:34:10
alan278
Registered: Mar 26 2009
Posts: 3

Hi,
Newbie here.
Can an acrobat form be setup to allow data to be copied and pasted from excel?
For example, say 5 numbers in 5 rows in one column in excel could be copied and then pasted into 5 sequential vertical fields in an acrobat form.
thanks.

My Product Information:
Acrobat Pro 7.0, Windows
Top
2009-03-26 11:32:18
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Why yes, it can.

Step 1: Export data from excel file as "Tab Delimited Text File"
(Columns must have labels)
Step 2: Open PDF Form in Acrobat
Step 3: Select the "File > Form Data > Import Data" menu item
Step 4: Select the ".txt" file extension
Step 5: Select your exported excel file

This imports one line of the excel data into your form. Fields on the form must have the exact same names as the column names in the excel file.

Obviously this isn't exactly what you would like. In order to fill fields from several rows in the excel file you would need to write a script to handle the data transfer.

Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]

The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

Top