Forum: Ruby on Rails Exporting mysql data to excel?

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
dare r. (Guest)
on 2009-01-12 07:35
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
Robert W. (Guest)
on 2009-01-12 15:43
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.
Kaushik katari (Guest)
on 2009-01-12 19:17
(Received via mailing list)
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 W. <
This topic is locked and can not be replied to.