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

tidyxl

Read Untidy Excel Files

Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <http://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.

Functions (14)

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: 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

Names and RGB values of Excel standard colours

xlsx_color_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

tidyxl

Read Untidy Excel Files

v1.0.7

GPL-3

Authors

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

Initial release

tidyxl

Functions (14)

tidyxl

We don't support your browser anymore