Dhtmlx grid excel using ror 3

Hi

has someone successfully exported dhtmlx grid using Ruby on Rails 3 to
Excel file?
I have followed the great tutorial here:


and successfully form the grid

what i need now is to generate it to excel
Say, after user filter the data s/he wants, click “Export to Excel”
button, and .xls is generated exactly like what is in the grid (after
filtering)

Could someone help providing sample script?
Provided here is the script for PHP / Java / ASP.NET :
http://www.dhtmlx.com/blog/?p=357
RoR 3 ???

Thanks a bunch,
ciz

I’m interested in this too.

This is Paul from DHTMLX. We might add the export script for Ruby on
Rails in the future. As for now, you can try to use the online export
service. Check this blog post: http://www.dhtmlx.com/blog/?p=1512

I’m not familiar with dhtmlx, but you can send_data the html table to an
.xls file with the excel mime-type and Excel will read it in -
formatting
should stay intact - although I don’t know what limitations on
formatting
may exist. Works with UTF-8 characters, too. OpenOffice will grok it -
other spreadsheet apps don’t seem to like it, though.

There’s a spreadsheet gem that will give you more fine grained control
(in
exchange for more work) over the .xls file, and produces a legit .xls
file,
which matters if you want to support more spreadsheet programs than just
Excel.

I’ve also seen XML Doc approaches. Search to_xls and you should find a
few
different options.


Chris
http://livingsocial.com | http://clabs.org

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs