setCellStyleForType-methods {XLConnect} | R Documentation |
Setting the cell style per data type for the DATATYPE style action
Description
Sets the cell style for a specific data type as used by the DATATYPE style action.
Usage
## S4 method for signature 'workbook'
setCellStyleForType(object,type,style)
Arguments
object |
The |
type |
The data type for which to set the |
style |
The |
Details
Based on the (cell) data type the DATATYPE style action (see setStyleAction
)
sets the cellstyle
for the corresponding cells. The data type
is normally specified via a
corresponding data type constant from the XLC
object.
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
, getCellStyleForType
,
setStyleAction
Examples
## Not run:
file.copy(system.file("demoFiles/template2.xlsx",
package = "XLConnect"),
"datatype.xlsx", overwrite = TRUE)
# Load workbook
wb <- loadWorkbook("datatype.xlsx")
# Create a new cell style to be used
cs <- createCellStyle(wb, name = "mystyle")
# Set data format (number format) as numbers with aligned fractions
setDataFormat(cs, format = "# ???/???")
# Define the above created cell style as style to be used for
# numerics
setCellStyleForType(wb, type = XLC$"DATA_TYPE.NUMERIC", style = cs)
# Could also say cs <- setCellStyleForType(wb, "numeric")
# Set style action to 'datatype'
setStyleAction(wb, XLC$"STYLE_ACTION.DATATYPE")
# Write built-in data set 'mtcars' to the named region
# 'mtcars' as defined by the Excel template.
writeNamedRegion(wb, mtcars, name = "mtcars")
# Save workbook
saveWorkbook(wb)
# clean up
file.remove("datatype.xlsx")
## End(Not run)
[Package XLConnect version 1.0.10 Index]