# Export to excel

**URL:** <https://www.ruby-forum.com/t/export-to-excel/165003>\
**Category:** Rails\
**Created:** [April 8, 2009, 7:16am UTC](https://www.ruby-forum.com/t/export-to-excel/165003 "2009-04-08T07:16:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [April 8, 2009, 7:16am UTC](https://www.ruby-forum.com/t/export-to-excel/165003/1 "2009-04-08T07:16:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [April 8, 2009, 11:28am UTC](https://www.ruby-forum.com/t/export-to-excel/165003/2 "2009-04-08T11:28:45Z")

</div>

2009/4/8 Sijo Kg [removed\_email\_address@domain.invalid](mailto: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](http://groups.google.com/group/rails-oceania/browse_thread/thread/9de19f779a944d2a/50438843fd8d4993?hl=en)

–  
Daniel B.

[http://blog.web17.com.au](http://blog.web17.com.au)

> **[GitHub - danielbush/sifs: The Simple Include-File System (for bash)](https://github.com/danielbush/sifs/tree/master)**
>
> master

> **[danielbush - Overview](https://github.com/danielbush)**
>
> danielbush has 33 repositories available. Follow their code on GitHub.

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [April 8, 2009, 11:47am UTC](https://www.ruby-forum.com/t/export-to-excel/165003/3 "2009-04-08T11:47:23Z")

</div>

Hi thanks for the reply . I saw

[http://spreadsheet.rubyforge.org/](http://spreadsheet.rubyforge.org/)

What about this? Have you used it?

Sijo

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [May 8, 2009, 6:22pm UTC](https://www.ruby-forum.com/t/export-to-excel/165003/4 "2009-05-08T18:22:29Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [April 8, 2009, 12:40pm UTC](https://www.ruby-forum.com/t/export-to-excel/165003/5 "2009-04-08T12:40:20Z")

</div>

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