SpreadsheetImporter

gem 'spreadsheet_importer'

Usage

  SpreadsheetImporter::Import.from_spreadsheet(spreadsheet) do |row|
    # Do some work on the row
  end

  # Starting at a custom offset
  SpreadsheetImporter::Import.from_spreadsheet(spreadsheet, :start_row => 5) do |row|

2D Array

  SpreadsheetImporter::Import.from_spreadsheet([["Bob", "Hoskins"], ["Roger", "Rabbit"]])

CSV

  SpreadsheetImporter::Import.from_csv("users.csv")

.xlsx

  SpreadsheetImporter::Import.from_xlsx("users.xlsx")
  SpreadsheetImporter::Import.from_xlsx("users.xlsx", :sheet_name => '2015') # Processing a single sheet