Dear all, Could anyone please suggest about how to export mysql data''s to excel. Is there any plugins or gem to do so? Thanks in advance regards, Jose Martin -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
dare ruby wrote:> Dear all, > > Could anyone please suggest about how to export mysql data''s to excel. > Is there any plugins or gem to do so?By far the simplest solution is to output to Comma Separated Value (CSV) files. Excel can open them as a spreadsheet. Ruby has a CSV class in it''s standard library for reading and writing CSV format. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
try the spreadsheets gem. it allows you to open up a spreadsheet and insert records into it. On Mon, Jan 12, 2009 at 5:43 AM, Robert Walker < rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > dare ruby wrote: > > Dear all, > > > > Could anyone please suggest about how to export mysql data''s to excel. > > Is there any plugins or gem to do so? > By far the simplest solution is to output to Comma Separated Value (CSV) > files. Excel can open them as a spreadsheet. Ruby has a CSV class in > it''s standard library for reading and writing CSV format. > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---