taichi-ishitani/rggen

View on GitHub
lib/rggen/builtins/loaders/register_map/xls_loader.rb

Summary

Maintainability
A
0 mins
Test Coverage
loader :register_map, :xls do
  def load_file(file)
    create_map(file) do |map|
      load_spreadsheet(file).each do |worksheet|
        map[worksheet.name] = worksheet.rows
      end
    end
  end

  def load_spreadsheet(file)
    Spreadsheet.open(file, 'rb') do |book|
      book.worksheets.select do |worksheet|
        worksheet.row_count > 0
      end
    end
  end
end