create_numfmt: Create number format

In openxlsx2: Read, Write and Edit 'xlsx' Files

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, formatCode)

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.

Value

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

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"
)

openxlsx2 documentation built on April 3, 2025, 8:40 p.m.