SpreadsheetClearCell

Clears the specified cell of all styles and values.

Method Signature

SpreadsheetClearCell(spreadsheetObj=[any], row=[any], column=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
row	NUMERIC	true	The row number (1-based).
column	NUMERIC	true	The column number (1-based).

Examples

Clear a cell of all content and formatting:

// Clear cell A1
var spreadsheet = SpreadsheetNew();
SpreadsheetSetCellValue( spreadsheet, 1, 1, "To be cleared" );
SpreadsheetClearCell( spreadsheet, 1, 1 );

Remove specific cell data:

// Clear cell while preserving adjacent cells
var spreadsheet = SpreadsheetRead( "/path/to/file.xlsx" );
SpreadsheetClearCell( spreadsheet, 5, 3 );  // Clear row 5, column 3

Related

• SpreadsheetClearCellRange() - Clear multiple cells

• SpreadsheetSetCellValue() - Set cell value

• SpreadsheetDeleteRow() - Delete entire row