Writing/saving very large xlsx file - Shiny server crashes

awalker89 / openxlsx

R package for .xlsx file reading and writing.

Other

364 stars 79 forks source link

Writing/saving very large xlsx file - Shiny server crashes #495

Open aavanesy opened 4 years ago

aavanesy commented 4 years ago

Expected Behavior

Code is very straightforward. Reads excel (100k+ rows, 12 columns, both text and numbers), does calculations, prints out same file + output sheet.

Actual Behavior

Run well on different PC's when running the shiny app locally. Crashes when run on a Shiny server. Same code runs well with less data. Nothing in the logs.

Version of openxlsx: latest
Version of R: 3.6.1 deployed on Ubuntu/AWS

ycphs commented 4 years ago

Hi,

That is the old repository for this R Package.

Please use the new one:

https://github.com/ycphs/openxlsx