hendris wrote:
I'm currently reading data from an excel spreadsheet. I'd like to read all the values of a field in excel into a single array and then display that array in a listbox. Am I right in assuming that I'll need to write some script for this or can this part be done through GUI. I havn't tackled opus script yet so I'm trying to keep as much of this in GUI as possible.
Whats the best way to tackle this even if I have to go the script route?
Also I notice when you are assigning Variables to fields after creating a query that if I choose array as a variable type the new variable will not be created. Is this a bug or as designed?
Shawn
Shawn
Yes, you will have to use script to do what you plan. Here is a post that will help in accessing your Excel data.
viewtopic.php?t=401&highlight=excel
The rest of the solution to your problem is simply assigning your variable(s) to a list. Try the example in the post from Robin Garrett above, then put a Listbox onto your test page and assign your data to it. Good luck.
pc_amethyst
Login
FAQ
Search
