[R] Problems with xlsx and rjava

[Lopez, Dan]

Hi Rui,

I started using package gdata instead. 

But the day I need to write back to I .xlsx I will plan to use XLConnect. I started reading the vignette and it didn't sound too bad. I like it.

Thanks.
Dan


-----Original Message-----
From: Rui Barradas [mailto:ruipbarradas at sapo.pt] 
Sent: Tuesday, October 16, 2012 11:16 AM
To: Lopez, Dan
Cc: R help (r-help at r-project.org)
Subject: Re: [R] Problems with xlsx and rjava

Hello,

I cannot answer directly to your question, but I had problems with package xlsx and for what I've seen on R-Help so had others. Maybe you are using the wrong architecture of R (32/64 bits).
Package XLConnect is more flexible and a bit more complex, but it comes with a vignette that explains how to use it.

Hope this helps,

Rui Barradas
Em 16-10-2012 18:57, Lopez, Dan escreveu:
> Hi,
>
> I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010).
>
> I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here:
> http://stackoverflow.com/questions/7019912/using-the-rjava-package-on-win7-64-bit-with-r
>                                  Where it says: install rJava 0.9.2.
>
> rJava.dll is located in the file path indicated by the error message below. Not sure why it's now saying "The specified path is invalid"
>
> Does anyone now the fix to this problem?
>
>> library(xlsx)
> Loading required package: xlsxjars
> Loading required package: rJava
> Error : .onLoad failed in loadNamespace() for 'rJava', details:
>    call: inDL(x, as.logical(local), as.logical(now), ...)
>    error: unable to load shared object 'C:/R/R-2.15.1/library/rJava/libs/i386/rJava.dll':
>    LoadLibrary failure:  The specified path is invalid.
>
>
> Daniel Lopez
> Workforce Analyst
> HRIM - Workforce Analytics & Metrics
> Strategic Human Resources Management
> wf-analytics-metrics at lists.llnl.gov<mailto:wf-analytics-metrics at lists.
> llnl.gov>
> (925) 422-0814
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.