Create an DataFormat object, useful when working with cell styles.
is.DataFormat(df)
DataFormat(x)An DataFormat object, as returned by DataFormat.
a character value specifying the data format.
DataFormat returns a list one component dataFormat, and a
class attribute "DataFormat". DataFormat objects are used when constructing
cell styles.
is.DataFormat returns TRUE if the argument is of class
"DataFormat" and FALSE otherwise.
Specifying the dataFormat argument allows you to format the cell.
For example, "#,##0.00" corresponds to using a comma separator for powers of
1000 with two decimal places, "m/d/yyyy" can be used to format dates and is
the equivalent of 's MM/DD/YYYY format. To format datetimes use "m/d/yyyy
h:mm:ss;@". To show negative values in red within parantheses with two
decimals and commas after power of 1000 use "#,##0.00_);[Red](#,##0.00)". I
am not aware of an official way to discover these strings. I find them out
by recording a macro that formats a specific cell and then checking out the
resulting VBA code. From there you can read the dataFormat code.
CellStyle for using the a DataFormat object.
df <- DataFormat("#,##0.00")