Drop-down lists and Excel???

[Former Community Member]

I am very new to LiveCycle, so please be kind. I want to have a spreadsheet that feeds (links to) my drop-down list choices...and if the spreadsheet changes, then the drop-down choices change. The spreadsheet won't change that often, but it would eliminate the need to re-enter the data that is already on the spreadsheet. Is this possible?



Thanks so much!!!

[Former Community Member]

You can connect to the Spreadsheet using an OLE/DB connection but I do not recommend that. You would have to create a datasource and maintain it on each machine. It becomes a maintenance nightmare. I understand what you are trying to do but the best way top accomplish this is by putting the representation of the XML spreadsheet on a server and use a Web Service to populate the drop down. If this is not possible then hard code the values into the template (as you point out they do not change very often).



One other option is to store all of the data into an XML file and import that data file into the form. The Spreadsheet is the limiting factot here.