11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
# File 'lib/remote_table/file/csv.rb', line 11
def each_row(&block)
backup_file!
convert_file_to_utf8!
remove_useless_characters!
skip_rows!
::RemoteTable::MyCSV.foreach(path, fastercsv_options) do |row|
ordered_hash = ActiveSupport::OrderedHash.new
filled_values = 0
case row
when ::RemoteTable::MyCSV::Row
row.each do |, value|
next if .blank?
value = '' if value.nil?
ordered_hash[] = value
filled_values += 1 if value.present?
end
when Array
index = 0
row.each do |value|
value = '' if value.nil?
ordered_hash[index] = value
filled_values += 1 if value.present?
index += 1
end
else
raise "Unexpected #{row.inspect}"
end
yield ordered_hash if keep_blank_rows or filled_values.nonzero?
end
ensure
restore_file!
end
|