spreadsheetClearCellRange

Clears the values and styles of a range of cells.

spreadsheetClearCellRange(spreadsheet, startRow, startColumn, endRow, endColumn) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

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.

Compatibility

RustCFML:

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

Examples
Sample code invoking the spreadsheetClearCellRange function

Clear the 2x3 range from B2 to D3.

wb = Spreadsheet("xlsx");
spreadsheetSetCellRangeValue(wb, "x", 2, 2, 3, 4);
spreadsheetClearCellRange(wb, 2, 2, 3, 4);

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

Fork me on GitHub