class POI::NamedRange

Public Class Methods

new(name, workbook) click to toggle source

takes an instance of org.apache.poi.ss.usermodel.Name, and a POI::Workbook

# File lib/poi/workbook/named_range.rb, line 5
def initialize name, workbook
  @name = name
  @workbook = workbook
end

Public Instance Methods

cells() click to toggle source
# File lib/poi/workbook/named_range.rb, line 22
def cells
  @name.is_deleted ? [] : [@workbook.cell(formula)].flatten
end
formula() click to toggle source
# File lib/poi/workbook/named_range.rb, line 18
def formula
  @name.refers_to_formula
end
name() click to toggle source
# File lib/poi/workbook/named_range.rb, line 10
def name
  @name.name_name
end
sheet() click to toggle source
# File lib/poi/workbook/named_range.rb, line 14
def sheet
  @workbook.worksheets[@name.sheet_name]
end
values() click to toggle source
# File lib/poi/workbook/named_range.rb, line 26
def values
  cells.collect{|c| c.value}
end