spreadsheetClearCell

Clears the value and style of a cell.

spreadsheetClearCell(spreadsheet, row, column) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

row numeric
Required

Row number (1-based).

column numeric
Required

Column number (1-based).

Compatibility

RustCFML:

Not supported on wasm32. Member form: clearCell(row, column).

Examples
Sample code invoking the spreadsheetClearCell function

Remove the value previously written to row 1, column 1.

wb = Spreadsheet("xlsx");
spreadsheetSetCellValue(wb, "temp", 1, 1);
spreadsheetClearCell(wb, 1, 1);
writeDump(spreadsheetGetCellValue(wb, 1, 1));

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

Fork me on GitHub