ESV
Ruby library/gem for Excel parsing and generation with the ease of CSV.
Exporting CSVs because Excel generation is too complex? No more!
CSVs can be difficult to open correctly, e.g. in Excel on Mac.
Usage
Generate data
require "esv"
data = ESV.generate do |esv|
esv << [ "Name", "Dogs", "Cats" ]
esv << [ "Victor", 1, 4 ]
end
File.write("/tmp/test.xls", data)
Generate file
require "esv"
ESV.generate_file("/tmp/test.xls") do |esv|
esv << [ "Name", "Dogs", "Cats" ]
esv << [ "Victor", 1, 4 ]
end
Parse data
require "esv"
data = File.read("/tmp/test.xls")
output = ESV.parse(data)
# => [ [ "Name", "Dogs", … ], … ]
This assumes a file with a single worksheet and will raise otherwise.
Parse file
require "esv"
output = ESV.parse_file("/tmp/test.xls")
# => [ [ "Name", "Dogs", … ], … ]
This assumes a file with a single worksheet and will raise otherwise.
Generate in Ruby on Rails
In config/initializers/mime_types.rb
:
Mime::Type.register ESV::MIME_TYPE, "xls"
As a model or whatever you prefer:
class MyExcelDocument
def self.generate(name)
ESV.generate { |esv| esv << [ "Hello #{name}" ] }
end
end
Controller:
class MyController < ApplicationController
include ESV::RailsController # for send_excel
def show
data = MyExcelDocument.generate("Rails")
send_excel(data)
end
def another_example
respond_to do |format|
format.html { … }
format.xls { send_excel(…) }
end
end
end
Installation
Add this line to your application's Gemfile:
gem 'excel-esv'
And then execute:
$ bundle
Or install it yourself as:
$ gem install excel-esv
Credits and license
By Henrik Nyh for Auctionet.com under the MIT license.
Using a lot of code from LivingSocial's Excelinator, also under the MIT license.
This library is a thin wrapper around Spreadsheet which does the heavy lifting.