Leading apostrophe is not displayed while dumping the Excel sheet into a MySQL database in a Rails 3 application

I am using a script to dump the data in to a MySQL database in a Rails 3 application.

I have a cell data in Excel sheet as:


While dumping it in to database it only shows as:


I am doing this on Fedora 15 and using the 'spreadsheet gem' in a script for dumping data.


  • This is resolved. I have inserted the ' by the script in the record in which ' is not present.