setCellRangeValue

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