Sets every cell in a range to the same value.
spreadsheetSetCellRangeValue(spreadsheet, value, startRow, startColumn, endRow, endColumn [, dataType])
→ returns void
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.