Export to Excel - large file

rubyonrails-talk
1

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

2

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

3

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

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