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