setCellStyleForType-methods | R Documentation |
Sets the cell style for a specific data type as used by the DATATYPE style action.
## S4 method for signature 'workbook' setCellStyleForType(object,type,style)
object |
The |
type |
The data type for which to set the |
style |
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
, getCellStyleForType
,
setStyleAction
## 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.