spreadsheetSetCellRangeValue

Sets every cell in a range to the same value.

spreadsheetSetCellRangeValue(spreadsheet, value, startRow, startColumn, endRow, endColumn [, dataType]) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

value any
Required

Value to set.

startRow numeric
Required

First row of the range.

startColumn numeric
Required

First column of the range.

endRow numeric
Required

Last row of the range.

endColumn numeric
Required

Last column of the range.

dataType string

Data type to set the cells to, such as string, numeric or date.

Compatibility

RustCFML:

Not supported on wasm32. Member form: setCellRangeValue(value, startRow, startColumn, endRow, endColumn).

Examples
Sample code invoking the spreadsheetSetCellRangeValue function

Fill the 2x2 range from A1 to B2 with a border colour value.

wb = Spreadsheet("xlsx");
spreadsheetSetCellRangeValue(wb, "pending", 1, 1, 2, 2);
writeDump(spreadsheetGetCellValue(wb, 2, 2));

Expected Result: pending

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub