Getting an error when deploying the app. (Error in library: there is no package called ‘xlsx’)

55 views
Skip to first unread message

Mikko Ritala

unread,
Jul 24, 2018, 6:44:24 AM7/24/18
to shinyapps.io Users
Logs:
2018-07-24T10:36:56.909817+00:00 shinyapps[386893]: Warning: Error in library: there is no package called ‘xlsx’
2018-07-24T10:36:56.921348+00:00 shinyapps[386893]:   61: stop
2018-07-24T10:36:56.921349+00:00 shinyapps[386893]:   60: library
2018-07-24T10:36:56.921350+00:00 shinyapps[386893]:   59: server [/srv/connect/apps/amvarasto/app.R#77]
2018-07-24T10:36:56.921516+00:00 shinyapps[386893]: Error in library(xlsx) : there is no package called ‘xlsx’
Does this mean xlsx-package is not usable in shinyapps.io?
My app does calculations and tables based on fileInput(.xlsx) user gives.
Also user is able to download these calculations as .xlsx files.
Do I have to use some other package or what is the problem?

Thank you in advance,
Mikko 

Mikko Ritala

unread,
Jul 24, 2018, 7:40:17 AM7/24/18
to shinyapps.io Users
Got same error with "XLConnect"-package. I always get this msg to console.
Read some stackoverflow posts and i feel like this is encoding issue bc I have lot of UTF-8 characaters in my code.

Warning messages:
1: In fileDependencies.R(file) :
  Failed to parse C:/Users/mikkoritala/AppData/Local/Temp/Rtmp8mxK5L/file231062e53608/app.R ; dependencies in this file will not be discovered.
2: Error detecting locale: Error in read.table(file = file, header = header, sep = sep, quote = quote, : incomplete final line found by readTableHeader on 'raw'
 (Using default: en_US) 

Mikko Ritala

unread,
Jul 24, 2018, 8:06:40 AM7/24/18
to shinyapps.io Users
Got it working after I ran this line in console. 

options(encoding = "UTF-8")

I still get Warning msg but app seems working fine.

Warning message:
Reply all
Reply to author
Forward
0 new messages