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

Import Excel values into drop-down

Forum Index > Forms: LiveCycle Designer > Import Excel values into drop-down
2011-09-08 09:08:34
NickiPT
Registered: May 24 2007
Posts: 12
Answered

I have 400+ values in an Excel sheet and their corresponding "values" in the adjacent column. Is there some way that I get these into my LiveCycle Designer dynamic PDF form without having to enter each item and its value individually?
 
I know that the newer LiveCycle Designer ES2 allows for when copying and pasting Excel fields and values into a drop-down menu, but I'm still waiting for approval to fund my software upgrade so in the meantime I'm stuck with ES.
 
My goal is to have the user select an item from the "District" drop-down and then have the corresponding district code populate the "DistrictCode" text field (read-only).

My Product Information:
LiveCycle Designer, Windows
Top
2011-09-08 13:27:16
#1
KellyMcC
Acrobat 9ExpertTeam
Registered: Jul 11 2011
Posts: 389
Here is a solution that may work for you, for now. It is from cookbooks.adobe.com:
http://cookbooks.adobe.com/post_Import_Excel_data_in_to_a_PDF_form-18755.php

Kelly McCathran
Adobe Community Expert
Certified Technical Trainer+

Top
2011-09-16 08:00:11
#2
NickiPT
Registered: May 24 2007
Posts: 12
Accepted Answer
Thank you!

Our IT folks installed LiveCycle ES2 on my machine the other day and I was able to copy and paste the values in with ease! Woo hoo!
Top