Export To Excel

[tomkins]

Hi, 

Does anyone know how I could export data currently being shown in a table plus to an excel readable file? eg .xls or .xml?

I am using Rails 2.3.5 and Hobo version 1.0.1

Thanks,

John.

[Bryan Larsen]

I've never exported xls, but exporting csv is pretty simple, and is a
great way to export to Excel and other spreadsheets.

http://railscasts.com/episodes/362-exporting-csv-and-excel

Bryan

> --
> You received this message because you are subscribed to the Google Groups
> "Hobo Users" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/hobousers/-/rSmEcjapjWYJ.
> To post to this group, send email to hobo...@googlegroups.com.
> To unsubscribe from this group, send email to
> hobousers+...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/hobousers?hl=en.

[kevinpfromnm]

In the last version of Excel I worked with, you can also bring in data straight from a web table.  Otherwise, if you're going to be doing it regularly, a csv export is probably the way to go.

[Ignacio Huerta]

Hi,

Another option is the "spreadsheet" gem. It exports to XLS and you can
easily add some styling (column width, column headers and things like
that).

Regards,
Ignacio


El 25/10/12 14:25, tomkins escribi�:

> -- You received this message because you are subscribed to the
> Google Groups "Hobo Users" group. To view this discussion on the
> web visit
> https://groups.google.com/d/msg/hobousers/-/rSmEcjapjWYJ. To post
> to this group, send email to hobo...@googlegroups.com. To
> unsubscribe from this group, send email to
> hobousers+...@googlegroups.com. For more options, visit
> this group at http://groups.google.com/group/hobousers?hl=en.

--
Ignacio Huerta Arteche
http://www.ihuerta.net
Tel�fono: 0034 645 70 77 35
Email realizado con software libre

[erbecke]

Spreadsheet is a very useful gem for Excel export/imports. 

[tomkins]

That guide says to put the line "require 'csv' " in config/application.rb but I don't have that file in my hobo app, so where should it go?

Thanks.

[Bryan Larsen]

All Rails 3 apps have a config/application.rb. If you have a Rails 2
application, config/environment.rb is the rough equivalent.

Bryan

> https://groups.google.com/d/msg/hobousers/-/l99Bf4-X1kEJ.