Shard Detail

xlsx-parser v0.8.0

Crystal wrapper for parsing .xlsx spreadsheets
crystal-lang spreadsheet xslx

Install & Use

Add the following code to your project's shard.yml under:

dependencies to use in production
- OR -
development_dependencies to use in development


xlsx-parser:
  github: D1ceWard/xlsx-parser

Readme

xlsx-parser (v0.8.0)

Crystal wrapper for parsing .xlsx spreadsheets

🚀 Suggestions for new improvements are welcome in the issue tracker.

Installation

  1. Add the dependency to your shard.yml:

    dependencies:
      xlsx-parser:
        github: D1ceWard/xlsx-parser
        version: 0.8.0
    
  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