getCellStyleForType-methods {XLConnect} | R Documentation |
Querying the cell style per data type for the DATATYPE style action
Description
Queries the cell style for a specific data type as used by the DATATYPE style action.
Usage
## S4 method for signature 'workbook'
getCellStyleForType(object,type)
Arguments
object |
The |
type |
The data type for which to get 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
, setCellStyleForType
,
setStyleAction
Examples
## Not run:
file.copy(system.file("demoFiles/template2.xlsx",
package = "XLConnect"),
"datatype.xlsx", overwrite = TRUE)
# Load workbook
wb <- loadWorkbook("datatype.xlsx")
# Get current (existing) cell style for numerics
cs <- getCellStyleForType(wb, XLC$"DATA_TYPE.NUMERIC")
# Could also say cs <- getCellStyleForType(wb, "numeric")
# Change style
setBorder(cs, side = c("bottom", "right"), type = XLC$"BORDER.THICK",
color = c(XLC$"COLOR.BLACK", XLC$"COLOR.RED"))
# 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]