Export to Excel - large file


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…


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.


You can try 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

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