create_numfmt {openxlsx2} | R Documentation |
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")
Arguments
numFmtId |
An ID representing the number format. The list of valid IDs can be found in the Details section of |
formatCode |
A format code that specifies the display format for numbers. This can include custom formats for dates, times, and other numeric values. |
Value
A formatted number format object to be used in a spreadsheet.
See Also
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"
)
[Package openxlsx2 version 1.17 Index]