Package index

Writing a workbook

xl_cell_general() as.character(<xl_cell_general>): General cell objects for Excel writing
xl_formula() xl_hyperlink() xl_hyperlink_cell(): Excel Types
xl_comment(): Create a cell comment
xl_rich_string() is_xl_rich_string() as.character(<xl_rich_string>): A cell whose text has several formats
xl_rich_run(): One run of a rich (multi-format) string
is_xl_comment(): Test whether an object is an `xl_comment`

xl_format() `+`(<xl_format>): Combine cell-formatting groups into a single format
xl_font() xl_fill() xl_border() xl_align() xl_num_format() xl_protection(): Cell formatting groups
xl_color(): Normalize a color to a libxlsxwriter RGB integer
is_xl_format(): Test whether an object is an `xl_format`

xl_sheet(): A worksheet with formatting and layout options
xl_col_spec() xl_row_spec(): Column and row specifications for a worksheet
xl_sheet_view(): How a worksheet appears when it opens
xl_page_setup(): How a worksheet prints
xl_outline(): Control how outline (grouping) symbols are drawn

xl_cond_cell() xl_cond_scale() xl_cond_bar() xl_cond_icons(): Format cells according to their contents
xl_validation(): Restrict what can be typed into a range
xl_filter(): Filter an autofilter column, hiding the rows that do not match
xl_filter_keep(): Which rows an Excel autofilter would leave visible
xl_table(): Add a worksheet table
xl_table_column(): Describe a column of a worksheet table
xl_merge(): Merge a range of cells