Skip to content
Julian Halliwell edited this page May 29, 2015 · 3 revisions

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

##Example

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