#362 Exporting CSV and Excel

ASCIIcast 362 - Exporting CSV and Excel

We can use an HTML table that contains the data we want to export as Excel has no problem displaying these. When we open this up in Excel we’ll see that the encoding problem has disappeared and data containing newlines is handled correctly, too. The spreadsheet looks a little different, though, as the HTML formatting adds a border to the cells and centre-aligns the header cells. We can customize this in the HTML document if we want any formatting we add will be shown in Excel. If we want to generate a file that feels more like a native Excel document we can change our template to look like this:

Full article: http://railscasts.com/episodes/362-exporting-csv-and-exce...