xlsx-parser (v0.5.1)

Crystal wrapper for parsing .xlsx spreadsheets

:rocket: Suggestions for improvement/new use cases are welcome.

Installation

  1. Add the dependency to your shard.yml:

    dependencies:
  xlsx-parser:
    github: D1ceWard/xlsx-parser
    version: 0.5.1

  2. Run shards install

Usage

With IO

require "xlsx-parser"

file_io = File.new("./my_super_spreadsheet.xlsx")
book = XlsxParser::Book.new(file_io)

With file path

require "xlsx-parser"

book = XlsxParser::Book.new("./my_super_spreadsheet.xlsx")

Print rows content

# Iterate on each row of the first sheet
book.sheets[0].rows.each do |row|
  puts row #=> { "A1" => "Col A Row 1", "B1" => "Col B Row 1" }
end

# Second sheet
book.sheets[1]

book.close

Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/D1ceWard/xlsx-parser. By contributing you agree to abide by the Code of Merit.

  1. Fork it (https://github.com/D1ceWard/xlsx-parser/fork)
  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 a new Pull Request

Contributors