Class: SpreadsheetStreamReader::BookReader

Inherits:
Object
  • Object
show all
Defined in:
lib/spreadsheet_stream_reader/book_reader.rb

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(file_path) ⇒ BookReader

Returns a new instance of BookReader.



8
9
10
11
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 8

def initialize(file_path)
  self.file_path = file_path.to_s
  self.file_ext = File.extname(file_path.to_s).downcase
end

Instance Attribute Details

#file_ext ⇒ Object

Returns the value of attribute file_ext.



6
7
8
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 6

def file_ext
  @file_ext
end

#file_path ⇒ Object

Returns the value of attribute file_path.



6
7
8
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 6

def file_path
  @file_path
end

Instance Method Details

#get_work_sheet(idx_or_name) ⇒ Object 



26
27
28
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 26

def get_work_sheet(idx_or_name)
  open_book.worksheet(idx_or_name)
end

#get_work_sheets ⇒ Object 



22
23
24
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 22

def get_work_sheets
  open_book.worksheets
end

#open_book ⇒ Object 



13
14
15
16
17
18
19
20
 
# File 'lib/spreadsheet_stream_reader/book_reader.rb', line 13

def open_book
  @open_book ||= case @file_ext
    when '.xls'
      Spreadsheet.open(@file_path)
    else
      nil
  end
end