tidyxl: xlsx_color_theme – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

xlsx_color_theme

Import theme color definitions from xlsx (Excel) files

Description

xlsx_color_theme() (alias xlsx_colour_theme() returns the names and RGB values of theme colours defined in xlsx (Excel) files. For example, "accent6" is the name of a theme colour in Excel, which could resolve to any RGB colour defined by the author of the file. Themes are often defined to comply with corporate standards.

Usage

xlsx_color_theme(path, check_filetype = TRUE)

xlsx_colour_theme(path, check_filetype = TRUE)

Arguments

`path`	Path to the xlsx file.
`check_filetype`	Logical. Whether to check that the filetype is xlsx (or xlsm) by looking at the file itself, rather than using the filename extension.

Value

A data frame, one row per colour, with the following columns.

name The name of the theme.
rgb The RGB colour that has been set for the theme in this file.

Examples

examples <- system.file("extdata/examples.xlsx", package = "tidyxl")
xlsx_color_theme(examples)
xlsx_colour_theme(examples)

tidyxl

Read Untidy Excel Files

v1.0.7

GPL-3

Authors

Duncan Garmonsway [aut, cre], Hadley Wickham [ctb] (Author of included readxl fragments), Jenny Bryan [ctb] (Author of included readxl fragments), RStudio [cph] (Copyright holder of included readxl fragments), Marcin Kalicinski [ctb, cph] (Author of included RapidXML code)

Initial release