Class: DataFile::Reader::Excel

Inherits:
Base
  • Object
show all
Defined in:
lib/data_file/reader/excel.rb

Instance Attribute Summary

Attributes inherited from Base

#reader

Instance Method Summary collapse

Methods inherited from Base

#initialize

Constructor Details

This class inherits a constructor from DataFile::Reader::Base

Instance Method Details

#headers ⇒ Object 



10
11
12
 
# File 'lib/data_file/reader/excel.rb', line 10

def headers
  defined?(POI) ? rows[0].cells.map(&:value) : rows[0].to_a
end

#operator ⇒ Object 



26
27
28
 
# File 'lib/data_file/reader/excel.rb', line 26

def operator
  defined?(POI) ? POI::Workbook : Spreadsheet
end

#rows ⇒ Object 



14
15
16
 
# File 'lib/data_file/reader/excel.rb', line 14

def rows
  worksheet.rows
end

#rows_index ⇒ Object 



22
23
24
 
# File 'lib/data_file/reader/excel.rb', line 22

def rows_index
  reader.options[:headers] ? 1 : 0
end

#rows_range ⇒ Object 



18
19
20
 
# File 'lib/data_file/reader/excel.rb', line 18

def rows_range
  (rows_index..rows.size)
end