Awesome

Fastsheet

Fastest ruby gem for reading Excel documents.

You should have rust installed to use this gem.

Add this line to your application's Gemfile:

gem 'fastsheet'

And then execute:

$ bundle

Or install it yourself as:

$ gem install fastsheet

Open a sheet:

require 'fastsheet'

sheet = Fastsheet::Sheet.new('path/to/sheet.xlsx')

# number of columns
sheet.width

# number of rows
sheet.height

Get rows or columns:

sheet.rows
sheet.columns

sheet.row(42)
sheet.column(1)

Iterators (returns enumerator if no block given):

sheet.each_row { |r| ... }
sheet.each_column { |c| ... }

That's all API for now. Feel free to open an issue if you need more.

Bug reports and pull requests are welcome on GitHub at https://github.com/dkkoval/fastsheet.

The gem is available as open source under the terms of the MIT License.