Skip to content
A simple yet powerful DSL to generate Excel spreadsheets built on top of axlsx gem.
Ruby
Latest commit 5835b43 Dec 14, 2012 @simsalabim Options trash magic
Failed to load latest commit information.
features Initial commit Dec 9, 2012
lib Options trash magic Dec 14, 2012
.gitignore Initial commit Dec 9, 2012
.travis.yml Initial commit Dec 9, 2012
Gemfile Initial commit Dec 9, 2012
LICENSE.txt Initial commit Dec 9, 2012
README.md Readme update Dec 9, 2012
Rakefile Initial commit Dec 9, 2012
lazy-wombat.gemspec Options trash magic Dec 14, 2012

README.md

LazyWombat Build Status

A simple yet powerful DSL to generate Excel spreadsheets built on top of axlsx gem.

Wombat picture

Why Lazy Wombat?

Axlsx is awesome and quite complex in usage. Often you need something simple and easy-to-use to generate an excel spreadsheet as easy, as you markup tables with HTML. Now you can.

Installation

Add this line to your application's Gemfile:

gem 'lazy-wombat', '~> 0.0.2'

And then execute:

$ bundle

Or install it yourself as:

$ gem install lazy-wombat

Usage

Basic sample: no styles, just content

Code

LazyWombat::Xlsx.new do
  spreadsheet do
    row do
      cell 'Cyberdyne Systems'
      cell 'Model 101'
      cell 'The Terminator'
    end
  end
end.save 'my_laziness.xlsx'

Or shortened:

LazyWombat::Xlsx.new do
  cell 'Cyberdyne Systems'
  cell 'Model 101'
  cell 'The Terminator'
end.save 'my_laziness.xlsx'

will create my_laziness.xlsx spreadsheet looks like this:

Generated spreadsheet

Since spreadsheet elements inheritance is alike spreadsheet -> row -> cell, you can arbitrary omit every unnecessary elder element of your spreadsheets.

Where is my HTML??

Oh yeah, I promised you as you markup tables with HTML: there're logic aliases: spreadsheet is table, row is tr, cell is, of course, td

Thus here's our simplest example:

LazyWombat::Xlsx.new do
  table do
    tr do
      td 'Cyberdyne Systems'
      td 'Model 101'
      td 'The Terminator'
    end
  end
end.save 'my_laziness.xlsx'

Additional options: spreadsheet names, rows and cells styles

By default spreadsheets are named as Sheet 1, Sheet 2, etc. It can be overwritten using name option.

LazyWombat::Xlsx.new do
  spreadsheet name: 'My Laziness' do
    row style: :bold do
      cell 'Cyberdyne Systems'
      cell 'Model 101', style: :italic
      cell 'The Terminator'
    end
  end
end.save 'my_laziness.xlsx'

Generated spreadsheet

Contributing

  1. Fork it
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create new Pull Request
Something went wrong with that request. Please try again.