Class: SpreadsheetRoo

Inherits:
AbstractSpreadsheet show all
Defined in:
lib/tmis/engine/import/spreadsheet_roo.rb

Overview

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(filepath) ⇒ SpreadsheetRoo

Contract String => Any



16
17
18
19
20
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 16

def initialize(filepath)
  @filepath = filepath.force_encoding("UTF-8")
  @sheet = Roo::Spreadsheet.open(@filepath)
  @sheet.default_sheet = 0
end

Instance Attribute Details

#filepath ⇒ Object (readonly)

Returns the value of attribute filepath.



13
14
15
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 13

def filepath
  @filepath
end

Instance Method Details

#[](r, c) ⇒ Object

Contract Pos, Pos => Any



48
49
50
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 48

def [](r, c)
  @sheet.cell(r, c)
end

#column(n) ⇒ Object

Contract Pos => Any



43
44
45
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 43

def column(n)
  @sheet.column(n)
end

#last_column ⇒ Object

Contract None => Pos



28
29
30
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 28

def last_column
  @sheet.last_column
end

#last_row ⇒ Object

Contract None => Pos



23
24
25
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 23

def last_row
  @sheet.last_row
end

#row(n) ⇒ Object

Contract Pos => Any



38
39
40
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 38

def row(n)
  @sheet.row(n)
end

#sheet(number) ⇒ Object

Contract Not => Any



33
34
35
 
# File 'lib/tmis/engine/import/spreadsheet_roo.rb', line 33

def sheet(number)
  @sheet.default_sheet = @sheet.sheets[number-1]
end