Sha256: 69982ca4252bfdef6431ebc5d43f6444222f0834a40665dd5467d99a9d55019a
Contents?: true
Size: 1.51 KB
Versions: 15
Compression:
Stored size: 1.51 KB
Contents
class Eco::API::Common::People::DefaultParsers::XLSParser < Eco::API::Common::Loaders::Parser
attribute :xls
attr_accessor :already_required
attr_reader :file
def parser(file, deps)
@file = file
rows.tap do |rws|
@file = nil
rws.each do |row|
to_string!(row)
end
end
end
def serializer(array_hash, deps)
raise "Not implemented. TODO: using axlsx or rubyXL gems. See: https://spin.atomicobject.com/2017/03/22/parsing-excel-files-ruby/"
end
private
def to_string!(row)
row.transform_values! do |val|
next nil unless val
next val if val.is_a?(String)
val.to_s
end
end
def headers
logger.warn("Headers detection is using your fields_map.json file (native behaviour)")
session.fields_mapper.list(:external).uniq
end
def sheet_name
0
end
def workbook
require_reading_libs!
Roo::Spreadsheet.open(file)
end
def spreadheet(name_or_index = sheet_name)
workbook.sheet(name_or_index)
end
def rows(target = headers)
begin
spreadheet.parse(header_search: target, clean: true)
rescue Roo::HeaderRowNotFoundError => e
missing = JSON.parse(e.message)
logger.warn("The input file is missing these headers: #{missing}")
present = target - missing
rows(present)
end
end
def require_reading_libs!
return if already_required
require 'roo'
require 'roo-xls'
already_required = true
end
end
Version data entries
15 entries across 15 versions & 1 rubygems