addDataValidation

Jump to bottom Edit New page

Julian Halliwell edited this page May 2, 2023 · 3 revisions

Adds a dataValidation object to a workbook's currently active sheet.

addDataValidation( workbook, dataValidation )

Required arguments

workbook spreadsheet object
dataValidation dataValidation object: built with newDataValidation()

Chainable? Yes.

Examples

dv = spreadsheet.newDataValidation()
  .onCells( "A1:B1" )
  .withValues( [ "London", "New York", "Paris" ] );
wb = spreadsheet.newXls();
spreadsheet.addDataValidation( wb, dv );