class RgGen::SpreadsheetLoader::XLSLoader

Public Instance Methods

read_spreadsheet(file, book) click to toggle source
# File lib/rggen/spreadsheet_loader/xls_loader.rb, line 10
def read_spreadsheet(file, book)
  read_xls(file).each do |sheet|
    book.add_sheet(sheet.name, sheet.rows)
  end
end

Private Instance Methods

read_xls(file) click to toggle source
# File lib/rggen/spreadsheet_loader/xls_loader.rb, line 18
def read_xls(file)
  require 'spreadsheet'
  ::Spreadsheet.open(file, 'rb') do |book|
    book.worksheets.select { |sheet| sheet.row_count.positive? }
  end
end