Function reference

All functions

excel_functions

Names of all Excel functions

is_date_format()

Test that Excel number formats are date formats

is_range()

Test that Excel formulas are ranges

maybe_xlsx()

Determine file format

tidy_xlsx()

Import xlsx (Excel) cell contents into a tidy structure.

tidyxl tidyxl-package

tidyxl: Import xlsx (Excel) spreadsheet data and formatting into tidy structures.

xlex()

Parse xlsx (Excel) formulas into tokens

xlsx_cells()

Import xlsx (Excel) cell contents into a tidy structure.

xlsx_color_standard xlsx_colour_standard

Names and RGB values of Excel standard colours

xlsx_color_theme() xlsx_colour_theme()

Import theme color definitions from xlsx (Excel) files

xlsx_formats()

Import xlsx (Excel) formatting definitions.

xlsx_names()

Import named formulas from xlsx (Excel) files

xlsx_sheet_names()

List sheets in an xlsx (Excel) file

xlsx_validation()

Import data validation rules of cells in xlsx (Excel) files