Method: OpenC3::ExcelSpreadsheet::ExcelWorksheet#initialize

Defined in:
lib/openc3/win32/excel.rb

#initialize(worksheet) ⇒ ExcelWorksheet

Returns a new instance of ExcelWorksheet.

Parameters:

  • worksheet (WIN32OLE) —

    The underlying Excel worksheet object



36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
 
# File 'lib/openc3/win32/excel.rb', line 36

def initialize(worksheet)
  @name = worksheet.name
  @num_rows = worksheet.UsedRange.rows.count
  @num_columns = worksheet.UsedRange.columns.count

  # Get Excel Data from Worksheet
  @data = worksheet.UsedRange.value

  # Build a lookup table based on the first column
  @lkup = {}
  if @data
    @data.each do |row|
      @lkup[row[0]] = row[1..-1]
    end
  end
end