Export to Excel - large file

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

On Oct 26, 4:57 pm, “Craig D.” [email protected]