Getting information from xls file to show on drop down list in rails

[NN Dodhia]

Hey i have an excel file with 2 columns, and i want to get them so that a user can select one of the rows in a drop down list or as an auto complete form, any ideas on how this is done, i know i can type out all the selections using f.input :collection ["1","2"......"100"] but there are about 100 rows so typing it would be tedious.

Any help would be appreciated.

[Dheeraj Kumar]

Use an iterator. A loop, if you prefer that term. Google ruby loops to get an overview of different constructs ruby supports.

You really should go back to a ruby book

On Mar 17, 2013 7:54 PM, "NN Dodhia" <aca1...@sheffield.ac.uk> wrote:

Hey i have an excel file with 2 columns, and i want to get them so that a user can select one of the rows in a drop down list or as an auto complete form, any ideas on how this is done, i know i can type out all the selections using f.input :collection ["1","2"......"100"] but there are about 100 rows so typing it would be tedious.

Any help would be appreciated.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/IvH-B81kBfUJ.
For more options, visit https://groups.google.com/groups/opt_out.