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