thirtyseven/dullard

*UNMAINTAINED* A lightweight, fast XLSX reader

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!

dullard's Issues

License missing from gemspec

Some companies will only use gems with a certain license.
The canonical and easy way to check is via the gemspec,

via e.g.

spec.license = 'MIT'
# or
spec.licenses = ['MIT', 'GPL-2']

Even for projects that already specify a license, including a license in your gemspec is a good practice, since it is easily
discoverable there without having to check the readme or for a license file.

For example, there is a License Finder gem to help companies ensure all gems they use
meet their licensing needs. This tool depends on license information being available in the gemspec. This is an important enough
issue that even Bundler now generates gems with a default 'MIT' license.

If you need help choosing a license (sorry, I haven't checked your readme or looked for a license file),
github has created a license picker tool.

In case you're wondering how I found you and why I made this issue, it's because I'm collecting stats on gems (I was originally
looking for download data) and decided to collect license metadata,too, and make issues for gemspecs not specifying a license as a public service :).

I hope you'll consider specifying a license in your gemspec. If not, please just close the issue and let me know. In either case, I'll follow up. Thanks!

p.s. I've written a blog post about this project

Support date parsing

bad value for range (ArgumentError)

I tried parsing a excel sheet with a couple of rows missing and ran into this error.

blank cell doesn't show up, breaks the 2D array

First of all thanks for making a clear and concise library to parse xlsx.

I am parsing xlsx with 1000s of rows and this does the parsing very fast. I am running into issues, when a cell doesn't have data, I think it should return nil, but it doesn't.

Dullard doesn't show nil on beginning of a row

expected behavior:

# one row:
[ nil, nil, nil, 1]

current behavior:

[ 1 ]

NoMethodError - undefined method `to_i' for #<DateTime

NoMethodError - undefined method `to_i' for #<DateTime:>:
        ~/.gem/ruby/2.1.0/gems/dullard-0.1.0/lib/dullard/reader.rb:234:in `block (2 levels) in rows'

the possible correction of that line of code:

row << ((shared and value.respond_to? :to_i) ? string_lookup(value.to_i) : value)

uninitialized constant Dullard::DateTime (NameError)

It needs a require "date" at the top.

$ ruby -v
ruby 2.2.0p0 (2014-12-25 revision 49005) [x86_64-darwin13]

Want a PR?