Importing of excel data to MySQL database is more easier in Rails3 using roo gem.

Following is a basic example to demonstrate how to get the data from an excel sheet and save to your database. Suppose you have an excel sheet named student_details.xls which contain the student details such as .Name.,”Phone.,.Address..We have to save them in our database but it will take a huge time if we insert them […]
Continue reading…