CRAN/E | tidyxl

tidyxl

Read Untidy Excel Files

Installation

About

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 . Does not support '.xlsb' or '.xls'.

github.com/nacnudus/tidyxl
nacnudus.github.io/tidyxl/
Bug report File report

Key Metrics

Version 1.0.10
R ≥ 3.2.0
Published 2023-12-21 131 days ago
Needs compilation? yes
License MIT
License File
CRAN checks tidyxl results

Downloads

Yesterday 51 +538%
Last 7 days 411 +30%
Last 30 days 1.285 +3%
Last 90 days 3.977 -14%
Last 365 days 18.081 -44%

Maintainer

Maintainer

Duncan Garmonsway

nacnudus@gmail.com

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)

Material

README
NEWS
Reference manual
Package source

Vignettes

Data Validation Rules
Detecting Spreadsheet Smells with xlex()
Tidyxl

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

tidyxl archive

Depends

R ≥ 3.2.0

Imports

Rcpp

Suggests

testthat
here
knitr
rmarkdown
readxl
dplyr
tidyr
purrr
tibble
ggplot2
cellranger
openxlsx
rlang

LinkingTo

Rcpp
piton ≥ 1.0.0

Reverse Imports

scicomptools
unheadr
xlcutter

Reverse Suggests

unpivotr