Sha256: d76d05d3658d7dee301d5ef10494a2c251802aa89e532fce7144c7b98a243e95
Contents?: true
Size: 1.68 KB
Versions: 7
Compression:
Stored size: 1.68 KB
Contents
require 'roo/generic_spreadsheet'
require 'roo/csv'
class CsvxExtended < Csv
def read_cells(sheet=nil)
sheet = @default_sheet unless sheet
@cell_type = {} unless @cell_type
@cell = {} unless @cell
@first_row[sheet] = 1
@last_row[sheet] = 0
@first_column[sheet] = 1
@last_column[sheet] = 1
rownum = 1
CSV.foreach(@filename, {:col_sep => ";"}) do |row|
row.each_with_index do |elem,i|
@cell[[rownum,i+1]] = cell_postprocessing rownum,i+1, elem
@cell_type[[rownum,i+1]] = celltype_class @cell[[rownum,i+1]]
if i+1 > @last_column[sheet]
@last_column[sheet] += 1
end
end
rownum += 1
@last_row[sheet] += 1
end
@cells_read[sheet] = true
#-- adjust @first_row if neccessary
loop do
if !row(@first_row[sheet]).any? and @first_row[sheet] < @last_row[sheet]
@first_row[sheet] += 1
else
break
end
end
#-- adjust @last_row if neccessary
loop do
if !row(@last_row[sheet]).any? and @last_row[sheet] and
@last_row[sheet] > @first_row[sheet]
@last_row[sheet] -= 1
else
break
end
end
#-- adjust @first_column if neccessary
loop do
if !column(@first_column[sheet]).any? and
@first_column[sheet] and
@first_column[sheet] < @last_column[sheet]
@first_column[sheet] += 1
else
break
end
end
#-- adjust @last_column if neccessary
loop do
if !column(@last_column[sheet]).any? and
@last_column[sheet] and
@last_column[sheet] > @first_column[sheet]
@last_column[sheet] -= 1
else
break
end
end
end
end
Version data entries
7 entries across 7 versions & 1 rubygems