Problem Installing and Loading r2excel

[glenwang]

> install_github("kassambara/r2excel")
Downloading GitHub repo kassambara/r2excel@master
✔  checking for file ‘/private/var/folders/w5/l4gkl0p93wbgch51gnq7khm00000gn/T/RtmpHsU9t7/remotes36766a7fa1aa/kassambara-r2excel-4144fc5/DESCRIPTION’ ...
─  preparing ‘r2excel’:
✔  checking DESCRIPTION meta-information ...
─  checking for LF line-endings in source and make files and shell scripts
─  checking for empty or unneeded directories
─  building ‘r2excel_1.0.0.tar.gz’
   
* installing *source* package ‘r2excel’ ...
** R
** byte-compile and prepare package for lazy loading
Error: package or namespace load failed for ‘xlsx’:
 .onLoad failed in loadNamespace() for 'rJava', details:
  call: dyn.load(file, DLLpath = DLLpath, ...)
  error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so':
  dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so, 6): Library not loaded: /Library/Java/JavaVirtualMachines/jdk-9.jdk/Contents/Home/lib/server/libjvm.dylib
  Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/rJava/libs/rJava.so
  Reason: image not found
Error : package ‘xlsx’ could not be loaded
ERROR: lazy loading failed for package ‘r2excel’
* removing ‘/Library/Frameworks/R.framework/Versions/3.5/Resources/library/r2excel’
Error in i.p(...) : 
  (converted from warning) installation of package ‘/var/folders/w5/l4gkl0p93wbgch51gnq7khm00000gn/T//RtmpHsU9t7/file367627cccca3/r2excel_1.0.0.tar.gz’ had non-zero exit status
> library(r2excel)
Error in library(r2excel) : there is no package called ‘r2excel’

[glenwang]

Thanks to https://stackoverflow.com/questions/30738974/rjava-load-error-in-rstudio-r-after-upgrading-to-osx-yosemite

I resolved the rJava issue by,

remove the rJava package: remove.packages(rJava) close R install latest Java on you mac open terminal and type this command: sudo R CMD javareconf Open R and install rJava with this command:

install.packages("rJava", dependencies=TRUE, type="source")

[jhoreina]

Tienen disponible la versión de r2Excel para win 64 bits?

[liuyanguu]

This package was not built in 64 bits system so we cannot install it this way. But you can still use all the functions by clone the repo and source or just copy-paste "/R/r2excel.r". There is actually no need to install the package. This package is a nice and convenient wrapper of the xlsx package. Lots of thanks to the author. Really appreciate.