colorCells_xlsx: Coloring the columns specifying rows conditions

In usagi-san-dayo/UsagiSan: Edit summary-tables on a Excel-file

Description

Coloring the columns specifying rows conditions

Usage

colorCells_xlsx(
  dataName,
  fileName,
  sheetName,
  coloredCols,
  coloredCondition = NULL,
  cellColor,
  fontSize = 11,
  fontName = "Yu Gothic",
  fontColor = "#000000"
)

Arguments

dataName	The name of a csv-file you want to edit with coloring.
fileName	The name of a Excel-file you want to save as.
sheetName	The name of a EXCEL-sheet you want to color.
coloredCols	The Columns colored with the specified color.
coloredCondition	The condition for rows. This argument must be a logical vector in which TRUE components indicate row indices colored and neither FALSE components dose.
cellColor	The color you want to color with
fontSize	Font-size.
fontName	Font-name.
fontColor	The color of fonts.

See Also

Examples of this function can be found at https://multivariate-statistics.com/2021/05/14/r-programming-excel-cells-color/

usagi-san-dayo/UsagiSan documentation built on Dec. 29, 2021, 10:17 p.m.