Forum: Ruby on Rails export to excel

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
661ae6e97d0e16c2af2aaf7d197e8387?d=identicon&s=25 Sijo k g (sijo)
on 2009-04-08 07:16
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
9b4c04c050122bcea16a6f3376d680fa?d=identicon&s=25 Daniel Bush (danb)
on 2009-04-08 11:28
(Received via mailing list)
2009/4/8 Sijo Kg <rails-mailing-list@andreas-s.net>

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


--
Daniel Bush

http://blog.web17.com.au
http://github.com/danielbush/sifs/tree/master
http://github.com/danielbush
661ae6e97d0e16c2af2aaf7d197e8387?d=identicon&s=25 Sijo k g (sijo)
on 2009-04-08 11:47
Hi thanks for the reply . I saw

http://spreadsheet.rubyforge.org/

   What about this? Have you used it?

Sijo
7196c20396ad91a39932968691803d85?d=identicon&s=25 KARTHIKEYAN RANGASWAMY (Guest)
on 2009-04-08 12:40
(Received via mailing list)
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
18709079a981155a1990f0748eb40bdd?d=identicon&s=25 Rase In (rasein)
on 2009-05-08 18:22
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 code

Hi 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)
This topic is locked and can not be replied to.