Excel sheet having : Firstname Lastname venkat patchava How to map Excel sheet data to my applicatioin in ruby. Firstname : venkat Lastname : patchava Plaase help me in ASAP. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Fallen Phoenix
2010-Nov-25 08:33 UTC
Re: How to map Excel sheet data to my applicatioin in ruby.
Hey there chowdary, You can try the spreadsheet gem. I''ve used it myself in a couple projects "back in the day" and it can read and write Excel spreadsheets, and help you work with the data therein a bit more easily. http://rubygems.org/gems/spreadsheet The basic guide should be enough to hopefully get you up and running: http://spreadsheet.rubyforge.org/GUIDE_txt.html Good luck! On Nov 25, 1:24 am, chowdary <patchava9...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Excel sheet having : > Firstname Lastname > venkat patchava > > How to map Excel sheet data to my applicatioin in ruby. > Firstname : venkat > Lastname : patchava > > Plaase help me in ASAP.-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Colin Law
2010-Nov-25 09:06 UTC
Re: How to map Excel sheet data to my applicatioin in ruby.
On 25 November 2010 08:24, chowdary <patchava9999-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Excel sheet having : > Firstname Lastname > venkat patchava > > How to map Excel sheet data to my applicatioin in ruby. > Firstname : venkat > Lastname : patchavaDo you mean that you want Rails to read directly from the spreadsheet (in which case Fallen Phoenix''s suggestion of using the spreadsheet gem may be the way to go) or are you just trying to seed the db from the spreadsheet. If the latter then you could just export the data as csv and import it into the database (by coding it in seed.rb and then rake db:seed for example). Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.