Hi I have some data to be exported as well as imported to/from my rails application to Excel.Could anybody please point me some good advise on how to do this..Also expect some good links on the same Thanks in advance Sijo -- 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
2009/4/8 Sijo Kg <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>> > Hi > I have some data to be exported as well as imported to/from my > rails application to Excel.Could anybody please point me some good > advise on how to do this..Also expect some good links on the same > > Thanks in advance > Sijo > -- > Posted via http://www.ruby-forum.com/. > >The exporting bit came up on the roro list recently. See the last post in the thread. I''ve just been using csv format and fastercsv myself with some visual basic to help the end user. Often wondered about the xml format of excel as well... http://groups.google.com/group/rails-oceania/browse_thread/thread/9de19f779a944d2a/50438843fd8d4993?hl=en -- Daniel Bush http://blog.web17.com.au http://github.com/danielbush/sifs/tree/master http://github.com/danielbush --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi thanks for the reply . I saw http://spreadsheet.rubyforge.org/ What about this? Have you used it? Sijo -- 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
try for the spreadsheet-excel gem .you can google for spreadsheet-excel gem.You will get the sample code for it.if you dont get it just mail me i will provide you the sample code On Wed, Apr 8, 2009 at 2:57 PM, Daniel Bush <dlb.id.au-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > 2009/4/8 Sijo Kg <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> > >> >> Hi >> I have some data to be exported as well as imported to/from my >> rails application to Excel.Could anybody please point me some good >> advise on how to do this..Also expect some good links on the same >> >> Thanks in advance >> Sijo >> -- >> Posted via http://www.ruby-forum.com/. >> >> > The exporting bit came up on the roro list recently. See the last post in > the thread. I''ve just been using csv format and fastercsv myself with some > visual basic to help the end user. Often wondered about the xml format of > excel as well... > > > http://groups.google.com/group/rails-oceania/browse_thread/thread/9de19f779a944d2a/50438843fd8d4993?hl=en > > > -- > Daniel Bush > > http://blog.web17.com.au > http://github.com/danielbush/sifs/tree/master > http://github.com/danielbush > > > >--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
KARTHIKEYAN RANGASWAMY wrote:> try for the spreadsheet-excel gem .you can google for spreadsheet-excel > gem.You will get the sample code for it.if you dont get it just mail me > i > will provide you the sample codeHi Karthik, Can you guide me how to export data''s to Excel sheet, which i am taking it from Webpage; My code ..... .....code continues elements = get_text_fields(ie) elements.each{|e| p ''Name - '' + e.name p ''Value - '' + e.value .... ....code continues after executing i am getting "Value", "Name"; Now i need to export to Excel, Name as Header and Value in each cells (rows and columns) -- Posted via http://www.ruby-forum.com/.