Method: Axlsx::Worksheet#add_data_validation

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

#add_data_validation(cells, data_validation) ⇒ Object

Add data validation to this worksheet.

Parameters:

  • cells (String) —

    The cells the validation will apply to.

  • data_validation (hash) —

    options defining the validation to apply.

See Also:

  • for an example


394
395
396
397
398
 
# File 'lib/axlsx/workbook/worksheet/worksheet.rb', line 394

def add_data_validation(cells, data_validation)
  dv = DataValidation.new(data_validation)
  dv.sqref = cells
  data_validations << dv
end