tidyxl-package | R Documentation |
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.
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.
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]
Useful links:
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.