Skip to contents

xlsx_cells() imports data from spreadsheets without coercing it into a rectangle. Each cell is represented by a row in a data frame, giving the cell's address, contents, formula, height, width, and keys to look up the cell's formatting in the return value of xlsx_formats().

Usage

xlsx_cells(
  path,
  sheets = NA,
  check_filetype = TRUE,
  include_blank_cells = TRUE
)

Arguments

path

Path to the xlsx file.

sheets

Sheets to read. Either a character vector (the names of the sheets), an integer vector (the positions of the sheets), or NA (default, all sheets).

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.

include_blank_cells

Logical. Whether to include cells that have no value or formula (but might have formatting or comments). Useful when a whole column of cells has been formatted, but most are empty. Try setting this to FALSE if a spreadsheet seems too large to load.

Value

A data frame with the following columns.

  • sheet The worksheet that the cell is from.

  • address The cell address in A1 notation.

  • row The row number of a cell address (integer).

  • col The column number of a cell address (integer).

  • is_blank Whether or not the cell has a value

  • content Raw cell value before type conversion, useful for debugging.

  • data_type The type of a cell, referring to the following columns: error, logical, numeric, date, character, blank.

  • error The error value of a cell.

  • logical The boolean value of a cell.

  • numeric The numeric value of a cell.

  • date The date value of a cell.

  • character The string value of a cell.

  • formula The formula in a cell (see 'Details').

  • is_array Whether or not the formula is an array formula.

  • formula_ref The address of a range of cells group to which an array formula or shared formula applies (see 'Details').

  • formula_group The formula group to which the cell belongs (see 'Details').

  • comment The text of a comment attached to a cell.

  • height The height of a cell's row, in Excel's units.

  • width The width of a cell's column, in Excel's units.

  • row_outline_level The outline level of a cells's row.

  • col_outline_level The outline level of a cells's column.

  • style_format An index into a table of style formats x$formats$style (see 'Details').

  • local_format_id An index into a table of local cell formats x$formats$local (see 'Details').

Cell formatting is returned in xlsx_formats(). There are two types or scopes of formatting: 'style' formatting, such as Excel's built-in styles 'normal', 'bad', etc., and 'local' formatting, which overrides particular elements of the style, e.g. by making it bold. Both types are returned, in the $style and $local sublists of xlsx_formats(), with identical structures. To look up the local formatting of a given cell, take the cell's 'local_format_id' value (my_cells$data$Sheet1[1, "local_format_id"]), and use it as an index into the format structure. E.g. to look up the font size, my_formats$local$font$size[local_format_id]. To see all available formats, type str(my_formats$local).

Details

A cell has two 'values': its content, and sometimes also a formula. It also has formatting applied at the 'style' level, which can be locally overridden.

Content

Depending on the cell, the content may be a numeric value such as 365 or 365.25, it may represent a date/datetime in one of Excel's date/datetime systems, or it may be an index into an internal table of strings. xlsx_cells() attempts to infer the correct data type of each cell, returning its value in the appropriate column (error, logical, numeric, date, character). In case this cleverness is unhelpful, the unparsed value and type information is available in the 'content' and 'data_type' columns.

Formula

When a cell has a formula, the value in the 'content' column is the result of the formula the last time it was evaluated.

Certain groups of cells may share a formula that differs only by addresses referred to in the formula; such groups are identified by an index, the 'formula_group'. The xlsx (Excel) file format only records the formula against one cell in any group. xlsx_cells() propagates such formulas to the other cells in a group, making the necessary changes to relative addresses in the formula.

Array formulas may also apply to a group of cells, identified by an address 'formula_ref', but xlsx (Excel) file format only records the formula against one cell in the group. xlsx_cells() propagates such formulas to the other cells in a group. Unlike shared formulas, no changes to addresses in array formulas are necessary.

Formulas that refer to other workbooks currently do not name the workbooks directly, instead via indices such as [1]. It is planned to dereference these.

Formatting

Cell formatting is returned by xlsx_formats(). There are two types of formatting: 'style' formatting, such as Excel's built-in styles 'normal', 'bad', etc., and 'local' formatting, which overrides the style. These are returned in the $style and $local sublists of xlsx_formats(), with identical structures.

To look up the local formatting of a given cell, take the cell's local_format_id value (my_cells$Sheet1[1, "local_format_id"]), and use it as an index into the format structure. E.g. to look up the font size, my_formats$local$font$size[local_format_id]. To see all available formats, type str(my_formats$local).

Strings can be formatted within a cell, so that a single cell can contain substrings with different formatting. This in-cell formatting is available in the column character_formatted, which is a list-column of data frames. Each row of each data frame describes a substring and its formatting. For cells without a character value, character_formatted is NULL, so for further processing you might need to filter out the NULLs first.

Examples

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

# All sheets
str(xlsx_cells(examples))
#> tibble [586 × 24] (S3: tbl_df/tbl/data.frame)
#>  $ sheet              : chr [1:586] "Sheet1" "Sheet1" "Sheet1" "Sheet1" ...
#>  $ address            : chr [1:586] "A1" "B1" "A2" "B2" ...
#>  $ row                : int [1:586] 1 1 2 2 3 3 4 4 5 5 ...
#>  $ col                : int [1:586] 1 2 1 2 1 2 1 2 1 2 ...
#>  $ is_blank           : logi [1:586] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>  $ content            : chr [1:586] "#DIV/0!" "56" "1" "54" ...
#>  $ data_type          : chr [1:586] "error" "character" "logical" "character" ...
#>  $ error              : chr [1:586] "#DIV/0!" NA NA NA ...
#>  $ logical            : logi [1:586] NA NA TRUE NA FALSE NA ...
#>  $ numeric            : num [1:586] NA NA NA NA NA ...
#>  $ date               : POSIXct[1:586], format: NA NA ...
#>  $ character          : chr [1:586] NA "Error" NA "Boolean (true)" ...
#>  $ character_formatted:List of 586
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Error"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Boolean (true)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Boolean (false)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "integer"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "integer with higher-precision number formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "default date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Different built-in date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "custom date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "character"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "character"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "comment"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "comment with formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Currency format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Percent format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Scientific format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to logical"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to a number"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to date"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to a string"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "some formulas that are stored in groups"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "single-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "multi-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "multi-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula that refers to another file"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal' style but 'normal' has been modified from Excel's default to use Arial font"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "italic"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local italics applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local bold applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local underline applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local double underline applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bad"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'bad' style applied to this cell"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "badboldrightupindent"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'bad' style modified with bold font, right-and-up-aligned with an indent."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "custom style with custom date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "auto-font"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Automatic font colour"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "standardred"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'indexed' or standard red text"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "themeblue"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Blue text from the theme"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bluepattern"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Pattern but no background, blue from theme"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "stylealign"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Custom style 'stylealign' where the style is aligned to the centre."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [16 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:16] "in-cell" "bold" "italic" "underline" ...
#>   .. ..$ bold         : logi [1:16] FALSE TRUE FALSE FALSE FALSE FALSE ...
#>   .. ..$ italic       : logi [1:16] FALSE FALSE TRUE FALSE FALSE FALSE ...
#>   .. ..$ underline    : chr [1:16] NA NA NA "single" ...
#>   .. ..$ strike       : logi [1:16] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>   .. ..$ vertAlign    : chr [1:16] NA NA NA NA ...
#>   .. ..$ size         : num [1:16] 0 0 0 0 0 0 0 0 0 0 ...
#>   .. ..$ color_rgb    : chr [1:16] NA "FF000000" "FF000000" "FF000000" ...
#>   .. ..$ color_theme  : int [1:16] NA 2 2 2 2 2 2 2 2 2 ...
#>   .. ..$ color_indexed: int [1:16] NA NA NA NA NA NA NA NA NA NA ...
#>   .. ..$ color_tint   : num [1:16] NA NA NA NA NA NA NA NA NA NA ...
#>   .. ..$ font         : chr [1:16] "Calibri" "Calibri" "Calibri" "Calibri" ...
#>   .. ..$ family       : int [1:16] 2 2 2 2 2 2 2 2 2 2 ...
#>   .. ..$ scheme       : chr [1:16] "minor" "minor" "minor" "minor" ...
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "in-cellbolditalicunderlineunderlinedoublesingleaccountingdoubleaccountingstrikethroughsuperscriptsubscriptredth"| __truncated__
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "yellowfillunderline12arialstrikethroughsuperscript"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "More fancy inline-string formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bottomborderslant"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Slanted text"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "merged"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Cell merged into cell below"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "unprotected"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is not 'protected'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "unhidden"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is not 'hidden'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "locked"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is 'locked'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "themebackground1"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Text is formatted the colour 'Background1' from the theme, i.e. white."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [2 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:2] "in-cell-bold" "-not-bold"
#>   .. ..$ bold         : logi [1:2] TRUE FALSE
#>   .. ..$ italic       : logi [1:2] FALSE FALSE
#>   .. ..$ underline    : chr [1:2] NA NA
#>   .. ..$ strike       : logi [1:2] FALSE FALSE
#>   .. ..$ vertAlign    : chr [1:2] NA NA
#>   .. ..$ size         : num [1:2] 0 0
#>   .. ..$ color_rgb    : chr [1:2] "FF000000" NA
#>   .. ..$ color_theme  : int [1:2] 2 NA
#>   .. ..$ color_indexed: int [1:2] NA NA
#>   .. ..$ color_tint   : num [1:2] NA NA
#>   .. ..$ font         : chr [1:2] "Calibri" "Arial"
#>   .. ..$ family       : int [1:2] 2 2
#>   .. ..$ scheme       : chr [1:2] "minor" NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Bold applied in inline string (not at cell level)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [2 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:2] "in-cell-bold" "-not-bold"
#>   .. ..$ bold         : logi [1:2] NA FALSE
#>   .. ..$ italic       : logi [1:2] NA FALSE
#>   .. ..$ underline    : chr [1:2] NA NA
#>   .. ..$ strike       : logi [1:2] NA FALSE
#>   .. ..$ vertAlign    : chr [1:2] NA NA
#>   .. ..$ size         : num [1:2] NA 0
#>   .. ..$ color_rgb    : chr [1:2] NA NA
#>   .. ..$ color_theme  : int [1:2] NA NA
#>   .. ..$ color_indexed: int [1:2] NA NA
#>   .. ..$ color_tint   : num [1:2] NA NA
#>   .. ..$ font         : chr [1:2] NA "Arial"
#>   .. ..$ family       : int [1:2] NA 2
#>   .. ..$ scheme       : chr [1:2] NA NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Bold applied at cell level"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "diagonal-up"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Diagonal-up border"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   .. [list output truncated]
#>  $ formula            : chr [1:586] "1/0" NA NA NA ...
#>  $ is_array           : logi [1:586] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>  $ formula_ref        : chr [1:586] NA NA NA NA ...
#>  $ formula_group      : int [1:586] NA NA NA NA NA NA NA NA NA NA ...
#>  $ comment            : chr [1:586] NA NA NA NA ...
#>  $ height             : num [1:586] 14.2 14.2 14.2 14.2 14.2 ...
#>  $ width              : num [1:586] 19.4 68 19.4 68 19.4 ...
#>  $ row_outline_level  : num [1:586] 1 1 1 1 1 1 1 1 1 1 ...
#>  $ col_outline_level  : num [1:586] 1 1 1 1 1 1 1 1 1 1 ...
#>  $ style_format       : chr [1:586] "Normal" "Normal" "Normal" "Normal" ...
#>  $ local_format_id    : int [1:586] 1 1 1 1 1 1 1 1 5 1 ...

# Specific sheet either by position or by name
str(xlsx_cells(examples, 2))
#> tibble [2 × 24] (S3: tbl_df/tbl/data.frame)
#>  $ sheet              : chr [1:2] "1~`!@#$%^&()_-+={}|;\"'<,>." "1~`!@#$%^&()_-+={}|;\"'<,>."
#>  $ address            : chr [1:2] "B2" "B6"
#>  $ row                : int [1:2] 2 6
#>  $ col                : int [1:2] 2 2
#>  $ is_blank           : logi [1:2] FALSE FALSE
#>  $ content            : chr [1:2] "29" "30"
#>  $ data_type          : chr [1:2] "character" "character"
#>  $ error              : chr [1:2] NA NA
#>  $ logical            : logi [1:2] NA NA
#>  $ numeric            : num [1:2] NA NA
#>  $ date               : POSIXct[1:2], format: NA NA
#>  $ character          : chr [1:2] "empty first row and col" "This worksheet has a nasty name but can be imported nevertheless"
#>  $ character_formatted:List of 2
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "empty first row and col"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "This worksheet has a nasty name but can be imported nevertheless"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>  $ formula            : chr [1:2] NA NA
#>  $ is_array           : logi [1:2] FALSE FALSE
#>  $ formula_ref        : chr [1:2] NA NA
#>  $ formula_group      : int [1:2] NA NA
#>  $ comment            : chr [1:2] "nacnudus:\nComment3" NA
#>  $ height             : num [1:2] 14.2 14.2
#>  $ width              : num [1:2] 8.38 8.38
#>  $ row_outline_level  : num [1:2] 1 1
#>  $ col_outline_level  : num [1:2] 1 1
#>  $ style_format       : chr [1:2] "Normal" "Normal"
#>  $ local_format_id    : int [1:2] 1 1
str(xlsx_cells(examples, "Sheet1"))
#> tibble [395 × 24] (S3: tbl_df/tbl/data.frame)
#>  $ sheet              : chr [1:395] "Sheet1" "Sheet1" "Sheet1" "Sheet1" ...
#>  $ address            : chr [1:395] "A1" "B1" "A2" "B2" ...
#>  $ row                : int [1:395] 1 1 2 2 3 3 4 4 5 5 ...
#>  $ col                : int [1:395] 1 2 1 2 1 2 1 2 1 2 ...
#>  $ is_blank           : logi [1:395] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>  $ content            : chr [1:395] "#DIV/0!" "56" "1" "54" ...
#>  $ data_type          : chr [1:395] "error" "character" "logical" "character" ...
#>  $ error              : chr [1:395] "#DIV/0!" NA NA NA ...
#>  $ logical            : logi [1:395] NA NA TRUE NA FALSE NA ...
#>  $ numeric            : num [1:395] NA NA NA NA NA ...
#>  $ date               : POSIXct[1:395], format: NA NA ...
#>  $ character          : chr [1:395] NA "Error" NA "Boolean (true)" ...
#>  $ character_formatted:List of 395
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Error"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Boolean (true)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Boolean (false)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "integer"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "integer with higher-precision number formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "default date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Different built-in date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "custom date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "character"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "character"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "comment"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "comment with formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Currency format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Percent format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Scientific format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to logical"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to a number"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to date"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula evaluating to a string"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "some formulas that are stored in groups"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "single-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "multi-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "multi-cell array formula"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "formula that refers to another file"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal' style but 'normal' has been modified from Excel's default to use Arial font"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "italic"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local italics applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local bold applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local underline applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "normal"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'normal' style but with local double underline applied to this cell."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bad"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'bad' style applied to this cell"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "badboldrightupindent"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'bad' style modified with bold font, right-and-up-aligned with an indent."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "custom style with custom date format"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "auto-font"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Automatic font colour"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "standardred"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "'indexed' or standard red text"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "themeblue"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Blue text from the theme"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bluepattern"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Pattern but no background, blue from theme"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "stylealign"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Custom style 'stylealign' where the style is aligned to the centre."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [16 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:16] "in-cell" "bold" "italic" "underline" ...
#>   .. ..$ bold         : logi [1:16] FALSE TRUE FALSE FALSE FALSE FALSE ...
#>   .. ..$ italic       : logi [1:16] FALSE FALSE TRUE FALSE FALSE FALSE ...
#>   .. ..$ underline    : chr [1:16] NA NA NA "single" ...
#>   .. ..$ strike       : logi [1:16] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>   .. ..$ vertAlign    : chr [1:16] NA NA NA NA ...
#>   .. ..$ size         : num [1:16] 0 0 0 0 0 0 0 0 0 0 ...
#>   .. ..$ color_rgb    : chr [1:16] NA "FF000000" "FF000000" "FF000000" ...
#>   .. ..$ color_theme  : int [1:16] NA 2 2 2 2 2 2 2 2 2 ...
#>   .. ..$ color_indexed: int [1:16] NA NA NA NA NA NA NA NA NA NA ...
#>   .. ..$ color_tint   : num [1:16] NA NA NA NA NA NA NA NA NA NA ...
#>   .. ..$ font         : chr [1:16] "Calibri" "Calibri" "Calibri" "Calibri" ...
#>   .. ..$ family       : int [1:16] 2 2 2 2 2 2 2 2 2 2 ...
#>   .. ..$ scheme       : chr [1:16] "minor" "minor" "minor" "minor" ...
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "in-cellbolditalicunderlineunderlinedoublesingleaccountingdoubleaccountingstrikethroughsuperscriptsubscriptredth"| __truncated__
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "yellowfillunderline12arialstrikethroughsuperscript"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "More fancy inline-string formatting"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "bottomborderslant"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Slanted text"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "merged"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Cell merged into cell below"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : NULL
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "unprotected"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is not 'protected'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "unhidden"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is not 'hidden'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "locked"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "A cell that is 'locked'"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "themebackground1"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Text is formatted the colour 'Background1' from the theme, i.e. white."
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [2 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:2] "in-cell-bold" "-not-bold"
#>   .. ..$ bold         : logi [1:2] TRUE FALSE
#>   .. ..$ italic       : logi [1:2] FALSE FALSE
#>   .. ..$ underline    : chr [1:2] NA NA
#>   .. ..$ strike       : logi [1:2] FALSE FALSE
#>   .. ..$ vertAlign    : chr [1:2] NA NA
#>   .. ..$ size         : num [1:2] 0 0
#>   .. ..$ color_rgb    : chr [1:2] "FF000000" NA
#>   .. ..$ color_theme  : int [1:2] 2 NA
#>   .. ..$ color_indexed: int [1:2] NA NA
#>   .. ..$ color_tint   : num [1:2] NA NA
#>   .. ..$ font         : chr [1:2] "Calibri" "Arial"
#>   .. ..$ family       : int [1:2] 2 2
#>   .. ..$ scheme       : chr [1:2] "minor" NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Bold applied in inline string (not at cell level)"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [2 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr [1:2] "in-cell-bold" "-not-bold"
#>   .. ..$ bold         : logi [1:2] NA FALSE
#>   .. ..$ italic       : logi [1:2] NA FALSE
#>   .. ..$ underline    : chr [1:2] NA NA
#>   .. ..$ strike       : logi [1:2] NA FALSE
#>   .. ..$ vertAlign    : chr [1:2] NA NA
#>   .. ..$ size         : num [1:2] NA 0
#>   .. ..$ color_rgb    : chr [1:2] NA NA
#>   .. ..$ color_theme  : int [1:2] NA NA
#>   .. ..$ color_indexed: int [1:2] NA NA
#>   .. ..$ color_tint   : num [1:2] NA NA
#>   .. ..$ font         : chr [1:2] NA "Arial"
#>   .. ..$ family       : int [1:2] NA 2
#>   .. ..$ scheme       : chr [1:2] NA NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Bold applied at cell level"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "diagonal-up"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   ..$ : tibble [1 × 14] (S3: tbl_df/tbl/data.frame)
#>   .. ..$ character    : chr "Diagonal-up border"
#>   .. ..$ bold         : logi NA
#>   .. ..$ italic       : logi NA
#>   .. ..$ underline    : chr NA
#>   .. ..$ strike       : logi NA
#>   .. ..$ vertAlign    : chr NA
#>   .. ..$ size         : num NA
#>   .. ..$ color_rgb    : chr NA
#>   .. ..$ color_theme  : int NA
#>   .. ..$ color_indexed: int NA
#>   .. ..$ color_tint   : num NA
#>   .. ..$ font         : chr NA
#>   .. ..$ family       : int NA
#>   .. ..$ scheme       : chr NA
#>   .. [list output truncated]
#>  $ formula            : chr [1:395] "1/0" NA NA NA ...
#>  $ is_array           : logi [1:395] FALSE FALSE FALSE FALSE FALSE FALSE ...
#>  $ formula_ref        : chr [1:395] NA NA NA NA ...
#>  $ formula_group      : int [1:395] NA NA NA NA NA NA NA NA NA NA ...
#>  $ comment            : chr [1:395] NA NA NA NA ...
#>  $ height             : num [1:395] 14.2 14.2 14.2 14.2 14.2 ...
#>  $ width              : num [1:395] 19.4 68 19.4 68 19.4 ...
#>  $ row_outline_level  : num [1:395] 1 1 1 1 1 1 1 1 1 1 ...
#>  $ col_outline_level  : num [1:395] 1 1 1 1 1 1 1 1 1 1 ...
#>  $ style_format       : chr [1:395] "Normal" "Normal" "Normal" "Normal" ...
#>  $ local_format_id    : int [1:395] 1 1 1 1 1 1 1 1 5 1 ...

# The formats of particular cells can be retrieved like this:

Sheet1 <- xlsx_cells(examples, "Sheet1")
formats <- xlsx_formats(examples)

formats$local$font$bold[Sheet1$local_format_id]
#>   [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [13] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [25] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [37] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [49] FALSE FALSE FALSE FALSE FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE
#>  [61] FALSE FALSE  TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [73] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#>  [85] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE  TRUE
#>  [97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [121] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [133] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [145] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [157] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [181] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [217] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [241] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [253] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [265] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [325] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [337] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
#> [385] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
formats$style$font$bold[Sheet1$style_format]
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal   Percent    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal       Bad    Normal       Bad    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#> styledate    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal styledate    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal  Normal 2    Normal  Normal 2 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>  Normal 2  Normal 2  Normal 2  Normal 2  Normal 2  Normal 2  Normal 2    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>  Normal 2    Normal  Normal 2    Normal  Normal 2    Normal  Normal 2    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>  Normal 2    Normal  Normal 2    Normal  Normal 2    Normal  Normal 2    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>  Normal 2 Hyperlink  Normal 2 Hyperlink  Normal 2    Normal  Normal 2    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal  Normal 2    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal    Normal    Normal    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE     FALSE 
#>    Normal    Normal    Normal 
#>     FALSE     FALSE     FALSE 

# To filter for cells of a particular format, first filter the formats to get
# the relevant indices, and then filter the cells by those indices.
bold_indices <- which(formats$local$font$bold)
Sheet1[Sheet1$local_format_id %in% bold_indices, ]
#> # A tibble: 3 × 24
#>   sheet  address   row   col is_blank content data_type error logical numeric
#>   <chr>  <chr>   <int> <int> <lgl>    <chr>   <chr>     <chr> <lgl>     <dbl>
#> 1 Sheet1 A28        28     1 FALSE    0       character NA    NA           NA
#> 2 Sheet1 A32        32     1 FALSE    6       character NA    NA           NA
#> 3 Sheet1 A49        49     1 FALSE    12      character NA    NA           NA
#> # … with 14 more variables: date <dttm>, character <chr>,
#> #   character_formatted <list>, formula <chr>, is_array <lgl>,
#> #   formula_ref <chr>, formula_group <int>, comment <chr>, height <dbl>,
#> #   width <dbl>, row_outline_level <dbl>, col_outline_level <dbl>,
#> #   style_format <chr>, local_format_id <int>

# In-cell formatting is available in the `character_formatted` column as a
# data frame, one row per substring.
xlsx_cells(examples)$character_formatted[77]
#> [[1]]
#> # A tibble: 16 × 14
#>    character   bold  italic under…¹ strike vertA…²  size color…³ color…⁴ color…⁵
#>    <chr>       <lgl> <lgl>  <chr>   <lgl>  <chr>   <dbl> <chr>     <int>   <int>
#>  1 "in-cell"   FALSE FALSE  NA      FALSE  NA          0 NA           NA      NA
#>  2 "bold"      TRUE  FALSE  NA      FALSE  NA          0 FF0000…       2      NA
#>  3 "italic"    FALSE TRUE   NA      FALSE  NA          0 FF0000…       2      NA
#>  4 "underline" FALSE FALSE  single  FALSE  NA          0 FF0000…       2      NA
#>  5 "underline… FALSE FALSE  double  FALSE  NA          0 FF0000…       2      NA
#>  6 "singleacc… FALSE FALSE  single… FALSE  NA          0 FF0000…       2      NA
#>  7 "doubleacc… FALSE FALSE  double… FALSE  NA          0 FF0000…       2      NA
#>  8 "strikethr… FALSE FALSE  NA      TRUE   NA          0 FF0000…       2      NA
#>  9 "subscript" FALSE FALSE  NA      FALSE  subscr…     0 FF0000…       2      NA
#> 10 "superscri… FALSE FALSE  NA      FALSE  supers…     0 FF0000…       2      NA
#> 11 "red"       FALSE FALSE  NA      FALSE  NA          0 FFFF00…      NA      NA
#> 12 "theme"     FALSE FALSE  NA      FALSE  NA          0 FFC050…       6      NA
#> 13 "tint"      FALSE FALSE  NA      FALSE  NA          0 FFC050…       6      NA
#> 14 "size"      FALSE FALSE  NA      FALSE  NA          0 FFFF00…      NA      NA
#> 15 "arial"     FALSE FALSE  NA      FALSE  NA          0 FFFF00…      NA      NA
#> 16 "UTF8Stéph… FALSE FALSE  NA      FALSE  NA          0 FFFF00…      NA      NA
#> # … with 4 more variables: color_tint <dbl>, font <chr>, family <int>,
#> #   scheme <chr>, and abbreviated variable names ¹​underline, ²​vertAlign,
#> #   ³​color_rgb, ⁴​color_theme, ⁵​color_indexed
#>