Create an DataFormat object, useful when working with cell styles.
DataFormat(x)is.DataFormat(df)
a character value specifying the data format.
An DataFormat object, as returned by DataFormat
.
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 R'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.
# NOT RUN {
df <- DataFormat("#,##0.00")
# }
Run the code above in your browser using DataLab