Method: Axlsx::ProtectedRanges#add_range

Defined in:
lib/axlsx/workbook/worksheet/protected_ranges.rb

#add_range(cells) ⇒ Object

Adds a protected range

Parameters:

  • cells (Array|String) —

    A string range reference or array of cells that will be protected



17
18
19
20
21
22
23
24
25
 
# File 'lib/axlsx/workbook/worksheet/protected_ranges.rb', line 17

def add_range(cells)
 sqref = if cells.is_a?(String)
           cells
         elsif cells.is_a?(SimpleTypedList) || cells.is_a?(Array)
           Axlsx::cell_range(cells, false)
         end
 @list << ProtectedRange.new(:sqref => sqref, :name => "Range#{size}")
 last
end