Learn R Programming

vanddraabe (version 1.1.1)

openxlsxCellStyles: openxlsx Cell Style

Description

A collection of cell style formats for the openxlsx package.

Arguments

Details

A centralized location defining the cell styles removes the need to change the formatting in several functions and provides a way to standardize cell formatting throughout the results.

The cell styles for the openxlsx package are defined within the openxlsxCellStyle.R file.

The defined cell styles are:

  • cs.green: background: lime, font: green and bold

  • cs.pink: background: pink, font: red and bold

  • cs.amber: background: amber, font orange and bold

  • cs.0digits: integer?

  • cs.comma: comma delineated values; e.g., 1,234

  • cs.date: date formatted

  • cs.1digits: one digit after the decimal point

  • cs.2digits: two digits after the decimal point

  • cs.3digits: three digits after the decimal point

  • cs.4digits: four digits after the decimal point

  • cs.header: top row of table; font: black, bold, centered, with a line along the bottom of the cell

  • cs.titles.tables: top row of table; font: black, bold, and centered

See Also

Other "openxlsx functions": oxAlignOverlapSheet, oxClusterStatsSheet, oxClusterSummarySheet, oxInitWaterDataSheet, oxPDBcleanedSummarySheet, oxPlainDataSheet, oxRCSBinfoSheet, oxWaterOccurrenceSheet