Working With Rails

Use FasterCSV.Install this using

gem install fastercsv

For info on usage please refer
http://wiki.rubyonrails.org/rails/pages/HowtoExportDataAsCSV

Fastercsv gem is used like this
send_data csv_string, :type => ‘text/csv’, :filename => (params[:batch] + ’ ’ + params[:method].capitalize + ’ Export.exl’)
You can export data in any formet

Thank U soo much .

I just want to add that if your users are on IE then you can simply use a mime type of ‘application/vnd.ms-excel’ and used a table in the body and it will automatically load in Excel in the browser. This works well in a controlled environment like a company where every workstation has MS Office or a similar arrangement. It’s very slick and easy. You can even use javascript to launch the save or print window from this point which prompts the user to take action.

I haven’t tried this with Firefox and MS Office but I don’t think this will work.

Hello MR Raul Rubio,

Thanks for your info.
Actually I am very new to rubyonrais..just started to learn to work on rubyonrails.

I am not able to find a good book for rubyonrails here in Indian market.
If possible can you please help me out in working with excel in rails..If you have any good tutorial please send me..

Thanks
Sai