Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Render XLSX from Rails using existing views ( .*.html => .xlsx )
branch: master


to_spreadsheet is a gem that lets you render xls from your existing slim/haml/erb/etc views from Rails (>= 3.0). Build Status


Add it to your Gemfile:

gem 'to_spreadsheet'


In your controller:

# my_thingies_controller.rb
class MyThingiesController < ApplicationController
  respond_to :xls, :html
  def index
    @my_items = MyItem.all
    respond_to do |format|
      format.xlsx { render xlsx: :index, filename: "my_items_doc" }

In your view partial:

# _my_items.haml
  %caption My items
      %td ID
      %td Name
    - my_items.each do |my_item|
      %td(colspan="2") #{my_items.length}

In your index.xls.haml:

# index.xls.haml
= render 'my_items', my_items: @my_items

In your index.html.haml:

# index.html.haml
= link_to 'Download spreadsheet', my_items_url(format: :xlsx)
= render 'my_items', my_items: @my_items


Every table in the view will be converted to a separate sheet.
The sheet title will be assigned to the value of the table’s caption element if it exists.


You can define formats in your view file (local to the view) or in the initializer

format_xls '' do
  workbook use_autowidth: true
  sheet    orientation: landscape
  format 'th', b: true # bold
  format 'tbody tr', bg_color: lambda { |row| 'ddffdd' if row.index.odd? }
  format 'A3:B10', i: true # italic
  format column: 0, width: 35
  format 'td.custom', lambda { |cell| modify cell somehow.}
  # default value (fallback value when value is blank or 0 for integer / float)
  default 'td.price', 10

For the full list of supported properties head here:
In addition, for column formats, Axlsx columnInfo properties are also supported

Advanced formatting

to_spreadsheet associates HTML nodes with Axlsx objects as follows:

HTML tag Axlsx object
table worksheet
tr row
td, th cell

For example, to directly manipulate a worksheet:

format_xls do
  format 'table' do |worksheet|
    worksheet.add_chart ...
    # to get the associated Nokogiri node:
    el = context.to_xml_node(worksheet)


You can define “themes” – blocks of formatting code:

ToSpreadsheet.theme :zebra do
  format 'tr', bg_color: lambda { |row| 'ddffdd' if row.index.odd? }

And then use them:

format_xls 'table.zebra', ToSpreadsheet.theme(:zebra)


The default theme uses class names on td/th to cast values.
Here is the list of class to type mapping:

CSS class Format
decimal or float Decimal
num or int Integer
datetime DateTime (Chronic.parse)
date Date (Date.parse)
time Time (Chronic.parse)
Something went wrong with that request. Please try again.