tidyxl: excel_functions – R documentation

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

excel_functions

Names of all Excel functions

Description

A dataset containing the names of all functions available in Excel. This is useful for identifying user-defined functions in formulas tokenized by xlex().

Usage

excel_functions

Format

A character vector of length 600.

Details

Note that this includes future function names that are already reserved.

Source

Pages 26–27 of Microsoft's document "Excel (.xlsx) extensions to the office openxml spreadsheetml file format p.24" https://docs.microsoft.com/en-us/openspecs/office_standards/ms-xlsx/2c5dee00-eff2-4b22-92b6-0738acd4475e, revision 8.0 2017-06-20.

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