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

Package details

AuthorDuncan 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)
MaintainerDuncan Garmonsway <nacnudus@gmail.com>
LicenseMIT + file LICENSE
Version1.0.9
URL https://github.com/nacnudus/tidyxl https://nacnudus.github.io/tidyxl/
Package repositoryView on CRAN
Installation Install the latest version of this package by entering the following in R:
install.packages("tidyxl")

Try the tidyxl package in your browser

Any scripts or data that you put into this service are public.

tidyxl documentation built on Nov. 2, 2023, 5:11 p.m.