Method: Roo::Excelx#label

Defined in:
lib/roo/excelx.rb

#label(name) ⇒ Object

returns the row,col values of the labelled cell (nil,nil) if label is not defined



233
234
235
236
237
238
 
# File 'lib/roo/excelx.rb', line 233

def label(name)
  labels = workbook.defined_names
  return [nil, nil, nil] if labels.empty? || !labels.key?(name)

  [labels[name].row, labels[name].col, labels[name].sheet]
end