# Export to Excel - large file

**URL:** <https://www.ruby-forum.com/t/export-to-excel-large-file/151834>\
**Category:** Rails\
**Created:** [October 26, 2008, 4:46pm UTC](https://www.ruby-forum.com/t/export-to-excel-large-file/151834 "2008-10-26T16:46:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marcello\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/fbc32d/32.png) [@Marcello\_P](https://www.ruby-forum.com/u/Marcello_P)\
**Post date:** [October 26, 2008, 4:46pm UTC](https://www.ruby-forum.com/t/export-to-excel-large-file/151834/1 "2008-10-26T16:46:38Z")

</div>

Hello,  
I need to export some data to an Excel file.  
I’m using a xml view to do that.

But now, the file is too large, and taking almost 30 minutes to  
render…

Is there another way that I can do this ??

Thanks for any help…

Marcello

---

<div class="post-metadata">

**Author:** ![Marcello\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/fbc32d/32.png) [@Marcello\_P](https://www.ruby-forum.com/u/Marcello_P)\
**Post date:** [October 26, 2008, 4:57pm UTC](https://www.ruby-forum.com/t/export-to-excel-large-file/151834/2 "2008-10-26T16:57:48Z")

</div>

Whenever I’ve needed to export data for Excel, I’ve always exported a  
CSV  
file, since it’s quite easy to create and easy for Excel to open. I’ve  
used  
FasterCSV to generate the CSV file.

Regards,  
Craig

---

<div class="post-metadata">

**Author:** ![Marcello\_P](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/fbc32d/32.png) [@Marcello\_P](https://www.ruby-forum.com/u/Marcello_P)\
**Post date:** [October 26, 2008, 10:11pm UTC](https://www.ruby-forum.com/t/export-to-excel-large-file/151834/3 "2008-10-26T22:11:05Z")

</div>

You can try [http://spreadsheet.rubyforge.org/](http://spreadsheet.rubyforge.org/)

There are two ways to produce an Excel file from your data. Ole and  
Xml way.  
I like Xml way more.

Take look at [http://wiki.rubyonrails.org/rails/pages/HowToExportToExcel](http://wiki.rubyonrails.org/rails/pages/HowToExportToExcel)  
too.

Could you give us more information about Excel file or a sample so we  
can help you more.

On Oct 26, 4:57 pm, “Craig D.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)