getCellStyleForType-methods | 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 https://mirai-solutions.ch
workbook
, setCellStyleForType
,
setStyleAction
## 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.