openxlsx2 (version 1.16)

create_numfmt: Create number format

Description

This function creates a number format for a cell in a spreadsheet. Number formats define how numeric values are displayed, including dates, times, currencies, percentages, and more.

Usage

create_numfmt(numFmtId = 164, formatCode = "#,##0.00")

Value

A formatted number format object to be used in a spreadsheet.

Arguments

numFmtId

An ID representing the number format. The list of valid IDs can be found in the Details section of create_cell_style().

formatCode

A format code that specifies the display format for numbers. This can include custom formats for dates, times, and other numeric values.

See Also

wb_add_numfmt()

Other style creating functions: create_border(), create_cell_style(), create_colors_xml(), create_dxfs_style(), create_fill(), create_font(), create_tablestyle()

Examples

# Create a number format for currency
numfmt <- create_numfmt(
  numFmtId = 164,
  formatCode = "$#,##0.00"
)