addDataValidation - cfsimplicity/spreadsheet-cfml GitHub Wiki

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 );