Class: SpreadsheetToArray::FromExcel

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

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(byte_array) ⇒ FromExcel

Returns a new instance of FromExcel.



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
43
44
45
46
47
48
49
50
 
# File 'lib/spreadsheet_to_array.rb', line 16

def initialize(byte_array)

  require 'rjb'
  
  # JVM loading
  filedir = File.dirname(__FILE__) + '/.'
  # Memory settings
  memory = ['-Xms256M', '-Xmx512M']
  Rjb::load("#{filedir}/apache-poi/poi-3.7-20101029.jar", memory)
  
  # Import des packages Java
  begin
    @file_class               = Rjb::import('java.io.FileInputStream')
    @workbook_class           = Rjb::import('org.apache.poi.hssf.usermodel.HSSFWorkbook')
    @cell_class               = Rjb::import('org.apache.poi.hssf.usermodel.HSSFCell')
    @date_util_class          = Rjb::import('org.apache.poi.ss.usermodel.DateUtil')
    @byte_array_input_stream  = Rjb::import('java.io.ByteArrayInputStream')
  rescue
    raise "Impossible to load Java packages. Maybe the path of Apache POI is not correct."
  end      
  
  begin
    java_byte_array         = @byte_array_input_stream.new_with_sig('[B', byte_array)
    @book                   = @workbook_class.new(java_byte_array)
  rescue Exception => e
    raise "The document is not a valid Excel file: #{e}"
  end
  
  # Reglage du nom de la première feuille
  @sheet                    = @book.getSheetAt(0)
  
  # Valeurs récupérées depuis le tableur
  @values                   = []
  parse_sheet    
end

Instance Attribute Details

#values ⇒ Object (readonly)

Returns the value of attribute values.



14
15
16
 
# File 'lib/spreadsheet_to_array.rb', line 14

def values
  @values
end