getCellStyleForType-methods {XLConnect} | R Documentation |
Queries the cell style for a specific data type as used by the DATATYPE style action.
## S4 method for signature 'workbook' getCellStyleForType(object,type)
object |
The |
type |
The data type for which to get the |
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.
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, setCellStyleForType
,
setStyleAction
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)