setCellRangeValue - cfsimplicity/spreadsheet-cfml GitHub Wiki

Sets the same value to a range of cells. If the cells don't exist they will be created.

setCellRangeValue( workbook, value, startRow, endRow, startColumn, endColumn )

Required arguments

  • workbook spreadsheet object
  • value any: value to set
  • startRow numeric
  • endRow numeric
  • startColumn numeric
  • endColumn numeric

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.setCellRangeValue( workbook, "The same in all cells", 1, 2, 1, 1 );