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.
B736ee289a70ae21e323ed2f808dd0ce?d=identicon&s=25 dare ruby (martin_mercy2001)
on 2009-01-12 06: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
280b78a61a968391b7e07e912be102a8?d=identicon&s=25 Robert Walker (robert4723)
on 2009-01-12 14: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.
9f72aa5ee72bd13a8b443fbf3797944c?d=identicon&s=25 Kaushik katari (Guest)
on 2009-01-12 18: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 Walker <
This topic is locked and can not be replied to.