worksheet_write_blank

@brief Write a formatted blank worksheet cell.

@param worksheet pointer to a lxw_worksheet instance to be updated. @param row The zero indexed row number. @param col The zero indexed column number. @param format A pointer to a Format instance or NULL.

@return A #lxw_error code.

Write a blank cell specified by row and column:

@code worksheet_write_blank(worksheet, 1, 1, border_format); @endcode

This function is used to add formatting to a cell which doesn't contain a string or number value.

Excel differentiates between an "Empty" cell and a "Blank" cell. An Empty cell is a cell which doesn't contain data or formatting whilst a Blank cell doesn't contain data but does contain formatting. Excel stores Blank cells but ignores Empty cells.

As such, if you write an empty cell without formatting it is ignored.

Meta