xlsx (version 0.6.1)

"+.CellStyle": CellStyle construction.

Description

Create cell styles.

Usage

# S3 method for CellStyle
+(cs1, object)

Arguments

cs1

a CellStyle object.

object

an object to add. The object can be another CellStyle, a DataFormat, a Alignment, a Border, a Fill, a Font, or a CellProtection object.

Value

A CellStyle object.

Details

The style of the argument object takes precedence over the style of argument cs1.

Examples

# NOT RUN {
  cs <- CellStyle(wb) +
    Font(wb, heightInPoints=20, isBold=TRUE, isItalic=TRUE,
      name="Courier New", color="orange") + 
    Fill(backgroundColor="lavender", foregroundColor="lavender",
      pattern="SOLID_FOREGROUND") +
    Alignment(h="ALIGN_RIGHT")
   
  setCellStyle(cell.1, cellStyle1)  

  # you need to save the workbook now if you want to see this art
# }

Run the code above in your browser using DataCamp Workspace