Ruby Snippets

Create XLSX document

require 'rubygems'
require 'simple_xlsx'
require 'date'
SimpleXlsx::Serializer.new("test.xlsx") do |doc|
  doc.add_sheet("People") do |sheet|
    sheet.add_row(%w{DoB Name Occupation})
    sheet.add_row([Date.parse('03/21/2011'),
                   "Milton Friedman",
                   "Economist / Statistician"])
  end
end

Set UTF-8 encoding for source

# -*- coding: utf-8 -*-

Gem do not install documentation

Add the following snippet to file ~/.gemrc

install: --no-rdoc --no-ri 
update:  --no-rdoc --no-ri