Exporting mysql data to excel?

Rails
1

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

2

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.

3

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. <