setCellRangeValue

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 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

Chainable? Yes.

Example

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