Skip to content

readxl::read_excel fails with Error: vectorΒ #736

@hidekoji

Description

@hidekoji

Importing this Excel file with readxl::read_excel raises the Error: vector

Brief description of the problem

file <- tempfile(); download.file("https://www.dropbox.com/scl/fi/jirejqyyxig0cikk6i2bn/P_P1.xlsx?rlkey=iwhm91t9npo40596me1lewls8&dl=1", file); df <- readxl::read_excel(file)
#> Error: vector

> sessionInfo()
R version 4.3.0 (2023-04-21)
Platform: x86_64-apple-darwin20 (64-bit)
Running under: macOS Ventura 13.4.1

Matrix products: default
BLAS:   /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib 
LAPACK: /Library/Frameworks/R.framework/Versions/4.3-x86_64/Resources/lib/libRlapack.dylib;  LAPACK version 3.11.0

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

time zone: America/Los_Angeles
tzcode source: internal

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

loaded via a namespace (and not attached):
 [1] vctrs_0.6.3       zip_2.3.0         cli_3.6.1         knitr_1.43        rlang_1.1.1       xfun_0.40        
 [7] processx_3.8.2    stringi_1.7.12    glue_1.6.2        clipr_0.8.0       htmltools_0.5.6   ps_1.7.5         
[13] readxl_1.4.3      rmarkdown_2.24    fansi_1.0.4       grid_4.3.0        cellranger_1.1.0  evaluate_0.21    
[19] tibble_3.2.1      fastmap_1.1.1     yaml_2.3.7        openxlsx_4.2.5.2  lifecycle_1.0.3   compiler_4.3.0   
[25] fs_1.6.3          Rcpp_1.0.11       pkgconfig_2.0.3   rstudioapi_0.15.0 digest_0.6.33     lattice_0.21-8   
[31] R6_2.5.1          reprex_2.0.2      utf8_1.2.3        pillar_1.9.0      splines_4.3.0     callr_3.7.3      
[37] magrittr_2.0.3    Matrix_1.5-4      tools_4.3.0       withr_2.5.0       survival_3.5-5   

<sup>Created on 2023-08-28 with [reprex v2.0.2](https://reprex.tidyverse.org)</sup>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions