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.
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.
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!
Do 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