No release in over 3 years
Low commit activity in last 3 years
Makes it easy to import spreadsheets. Handles .csv and .xlsx formats as well as raw 2D arrays
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
 Dependencies
 Project Readme

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