moj-analytical-services / s3tools

Interact with files in s3 on the Analytical Platform
8 stars 2 forks source link

Problem reading xls file with maximum number of rows #45

Open markpurver opened 4 years ago

markpurver commented 4 years ago

Attempting to read a sheet from an xls file with the maximum 65,536 rows causes the following error in RStudio:

ERROR session hadabend; LOGGED FROM: rstudio::core::Error {anonymous}::rInit(const rstudio::r::session::RInitInfo&) /home/ubuntu/rstudio/src/cpp/session/SessionMain.cpp:563

Reading another sheet from the same file with around 40,000 rows causes no problems. I'm not sure at how many lines the issue occurs.

The same issue happens using read_using with FUN=read_excel. But reading the file locally using read_excel is fine with the maximum number of rows.