24 Jul '12, 4am

#362 Exporting CSV and Excel - RailsCasts

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

Tweets

“#362 Exporting CSV and Excel - RailsCasts”

railscasts.com 16 Jul '12, 3am

As you will see it is easy to add a CSV export option to Rails. Here I also show how to export for Excel in a variety of f...

ASCIIcast 362 - Exporting CSV and Excel

railscasts.com 15 Jul '12, 8pm

We can use an HTML table that contains the data we want to export as Excel has no problem displaying these. When we open t...

he @railscasts effect

rubygems.org 25 Jul '12, 3pm

rack-mini-profiler stats for 0.1.7 Overview 0.1.7 0.1.6 0.1.5 0.1.4 0.1.3 0.1.2 0.1.1 0.1 Page loading speed displayed on ...

Railscasts - About Railscasts:

Railscasts - About Railscasts:

railscasts.com 02 Aug '12, 8pm

RailsCasts is produced by Ryan Bates (rbates on Twitter and ryanb on GitHub). A new episode will be released each week fea...