style_sum_line: Style row with "Sum" in an Excel sheet

In NorwegianVeterinaryInstitute/OKplan: Tools to facilitate the Planning of the annual Surveillance Programmes

Style row with "Sum" in an Excel sheet

Description

Style the font to bold for the row with the text "Sum" in one cell. It is possible to use other text decoration, see createStyle. A line with the text "Sum" or another text as given as input to text will be styled.

Usage

style_sum_line(
  workbook = workbook,
  sheet = sheet,
  data,
  text = "Sum",
  text_decoration = "bold",
  ...
)

Arguments

workbook	[Workbook] A workbook object containing a worksheet.
sheet	[character(1)] The Excel sheet name.
data	[data.frame] The data that have been exported to the Excel sheet. Used to find column number and row number for the pretext for which the row should be styled.
text	[character(1)] The text in the cell for which the row should be styled. Defaults to "Sum".
text_decoration	[character(1)] The text decoration style that should be used, see createStyle. Defaults to "bold".
...	Other arguments to be passed to addStyle.

Details

The whole line will be styled.

Value

None. One row in the workbook object is styled.

Author(s)

Petter Hopp [e-mail]

NorwegianVeterinaryInstitute/OKplan documentation built on Dec. 20, 2024, 10:41 a.m.