Hi has someone successfully exported dhtmlx grid using Ruby on Rails 3 to Excel file? I have followed the great tutorial here: http://www.dhtmlx.com/blog/?p=426 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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I''m interested in this too. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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 -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.