awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
363 stars 79 forks source link

Unclear error message relating to file description after unusual read failure #523

Open allmedia-nz opened 3 years ago

allmedia-nz commented 3 years ago

Expected Behavior

I've documented this on stackoverflow here https://stackoverflow.com/questions/64995517/r-openxlsx-package-version-4-2-2-error-in-filedescription-xlsxfile-inv tAKBusCyclelane2019.xlsx

read.xlsx("tAKBusCyclelane2019.xlsx", sheet= "ProcData") Reads fine

j <- 6 filelist[j] targetsheet read.xlsx(filelist[j], sheet=targetsheet) Doesn't

Actual Behavior

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)

1.

2.

3.

sessionInfo()

ycphs commented 3 years ago

Could you please create this also at ycphs/openxlsx?

I am maintaining the active fork of the package.