[R-sig-teaching] Help on packages working with excell files

[Ista Zahn]

Hi Tu,

Yes, those Java dependencies suck. I recommend trying the readxl
package, it doesn't have any external dependencies and should be
easier to get it working.

Best,
Ista

On Mon, Jun 22, 2015 at 1:40 PM, Nguyen C. <nctu2006 at gmail.com> wrote:
> Dear friends,
> I am trying to install and use xlsx package. After installeing xlsx and
> rJava successfully, I type >library(xlsx) then R said :
> "library(xlsx)
> Loading required package: rJava
> Error : .onLoad failed in loadNamespace() for 'rJava', details:
>   call: fun(libname, pkgname)
>   error: No CurrentVersion entry in Software/JavaSoft registry! Try
> re-installing Java and make sure R and Java have matching architectures.
> Error: package ‘rJava’ could not be loaded"
> I did the same for gdata package,  after installing succesfully and calling
> library(gdata), I did:
>> myDf<-read.xls("levuan2kq.xls",sheet=1,header=TRUE)
> Error in findPerl(verbose = verbose) :
>   perl executable not found. Use perl= argument to specify the correct path.
> Error in file.exists(tfn) : invalid 'file' argument
>
> Till now, I could not use any package to work with excel file.
> Anyone can help me.
> Thanks,
> Tu
>
>         [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-teaching at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-teaching