file truncated

[dirkseidensticker]

Describe the bug
While building a parser for our pacakge c14bazAAR (CRAN), using openxlsx a xlsx table hosted on GitHub is truncated on import.

We use openxlsx::read.xlsx() in three parsers already (get_irdd.R, get_eubar.R, get_14sea.R) and all files were imported properly. I also tested it with some xlsx files I have on my system, and they worked fine as well.

Do you have any clue what is happening? Many thanks in advance!

To Reproduce

(used xlsx::read.xlsx for testing purposes)

db_url <- "https://github.com/eehh-stanford/price2020/raw/master/MesoRAD-v.1.1_FINAL_no_locations.xlsx"

# download data
temp <- tempfile(fileext = ".xlsx")
utils::download.file(url = db_url, destfile = temp, mode = "wb", quiet = TRUE)

head(
  openxlsx::read.xlsx(
    temp,
    sheet = 1)
)

head(xlsx::read.xlsx(
  temp,
  sheetIndex = 1)
)

Expected behavior

The entire workbook should be imported and not only columns H to J.

Screenshots

Desktop (please complete the following information):

• Windows 10 Pro (1903)
• R 4.0.2
• openxlsx 4.1.5

Additional context

Only opening the file in Excel and saving it again worked, but this is no solution for our parser.

[dirkseidensticker]

Tested read.xlsx() on that specific file from a UbuntuVM and got the same, truncated result.

[dirkseidensticker]

we moved our codebase over to readxl & writexl; see ropensci/c14bazAAR#111