worksheet_write_number

@brief Write a number to a 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 number The number to write to the cell. @param format A pointer to a Format instance or NULL.

@return A #lxw_error code.

The worksheet_write_number() function writes numeric types to the cell specified by row and column:

@code worksheet_write_number(worksheet, 0, 0, 123456, NULL); worksheet_write_number(worksheet, 1, 0, 2.3451, NULL); @endcode

@image html write_number01.png

The native data type for all numbers in Excel is a IEEE-754 64-bit double-precision floating point, which is also the default type used by %worksheet_write_number.

The format parameter is used to apply formatting to the cell. This parameter can be NULL to indicate no formatting or it can be a @ref format.h "Format" object.

@code lxw_format *format = workbook_add_format(workbook); format_set_num_format(format, "$#,##0.00");

worksheet_write_number(worksheet, 0, 0, 1234.567, format); @endcode

@image html write_number02.png

extern (C)
worksheet_write_number

Meta