Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

CellStyle-plus

CellStyle construction.


Description

Create cell styles.

Usage

## S3 method for class '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.

Details

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

Value

A CellStyle object.

Author(s)

Adrian Dragulescu

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

## End(Not run)

xlsx

Read, Write, Format Excel 2007 and Excel 97/2000/XP/2003 Files

v0.6.5
GPL-3
Authors
Adrian Dragulescu [aut], Cole Arendt [aut, cre]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.