Export to excel


#1

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


#2

2009/4/8 Sijo Kg removed_email_address@domain.invalid

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 B.

http://blog.web17.com.au
http://github.com/danielbush/sifs/tree/master
http://github.com/danielbush


#3

Hi thanks for the reply . I saw

http://spreadsheet.rubyforge.org/

What about this? Have you used it?

Sijo


#4

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)


#5

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