Project

dullard

0.05
No release in over 3 years
Low commit activity in last 3 years
There's a lot of open issues
A fast XLSX parser using Nokogiri
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
 Project Readme

dullard

This gem is no longer maintained

Use roo or creek for streaming xlsx parsing.

Super simple, super fast stream-based XLSX parsing. Suitable for very large files.

Requires Ruby 2.0 or later.

require 'dullard' 

workbook = Dullard::Workbook.new "file.xlsx"
workbook.sheets[0].rows.each do |row|
  p row # => ["a","b","c", 0.3, #<DateTime: -4712-01-01....>, ...]
end

Current limitations

  • Limited validation and error handling.
  • Formatted cells are read minus formatting.
  • Rows that end with empty cells may be truncated.
  • Less common XLSX features (i.e., inline strings, 1904 date mode) may not work.
  • May be buggy. Pull requests welcome!