tidyxl-package: tidyxl: Import xlsx (Excel) spreadsheet data and formatting...

tidyxl-packageR Documentation

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

Description

Tidyxl imports data from spreadsheets without coercing it into a rectangle, and retains information encoded in cell formatting (e.g. font/fill/border). This data structure is compatible with the 'unpivotr' package for recognising information expressed by relative cell positions and cell formatting, and re-expressing it in a tidy way.

Details

  • xlsx_cells() Import cells from an xlsx file.

  • xlsx_formats() Import formatting from an xlsx file.

  • xlsx_sheet_names() List the names of sheets in an xlsx file.

  • xlsx_names() Import names and definitions of named ranges (aka 'named formulas', 'defined names') from an xlsx file.

  • is_range() Test whether a 'name' from xlsx_names() refers to a range or not.

  • xlsx_validation() Import cell input validation rules (e.g. 'must be from this drop-down list') from an xlsx file.

  • xlsx_colour_standard() A data frame of standard colour names and their RGB values.

  • xlsx_colour_theme() Imports a data frame of theme colour names and their RGB values from an xlsx file.

  • xlex() Tokenise (lex) an Excel formula.

Author(s)

Maintainer: Duncan Garmonsway nacnudus@gmail.com

Other contributors:

  • Hadley Wickham (Author of included readxl fragments) [contributor]

  • Jenny Bryan (Author of included readxl fragments) [contributor]

  • RStudio (Copyright holder of included readxl fragments) [copyright holder]

  • Marcin Kalicinski (Author of included RapidXML code) [contributor, copyright holder]

See Also

Useful links:


tidyxl documentation built on May 29, 2024, 2:34 a.m.