class RgGen::SpreadsheetLoader::CSVLoader

Public Instance Methods

read_spreadsheet(file, book) click to toggle source
# File lib/rggen/spreadsheet_loader/csv_loader.rb, line 10
def read_spreadsheet(file, book)
  sheet = read_csv(file)
  sheet_name = File.basename(file, '.*')
  book.add_sheet(sheet_name, sheet)
end

Private Instance Methods

read_csv(file) click to toggle source
# File lib/rggen/spreadsheet_loader/csv_loader.rb, line 18
def read_csv(file)
  require 'csv'
  CSV.read(file, col_sep: separator(file))
end
separator(file) click to toggle source
# File lib/rggen/spreadsheet_loader/csv_loader.rb, line 23
def separator(file)
  ext = File.extname(file)
  ext.casecmp?('.tsv') && "\t" || ','
end