tidyxl1.0.10 package

Read Untidy Excel Files

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

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

xlex

Parse xlsx (Excel) formulas into tokens

xlsx_cells

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

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

Download source packageRead PDF manual

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 <https://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.

  • Maintainer: Duncan Garmonsway
  • License: MIT + file LICENSE
  • Last published: 2023-12-21

Useful links