[R-SIG-Mac] using package xlsx

[Arnstein Gjestland]

Hi

Perhaps you should try the openxlsx package.

openxlsx: Read, Write and Edit XLSX Files

Simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

It helped me.

Arnstein

> 8. apr. 2015 kl. 23.12 skrev Dennis Fisher <fisher at plessthan.com>:
>
> OS X Yosemite
> R 3.1.3
>
> Colleagues
>
> I have used the package xlsx successfully in the past.  Today, I attempted to use that package, the first time since I upgraded to Yosemite.  R responded to:
>       library(“xlsx”)
> with
>       No Java runtime present, requesting install.
> A popup then said “you need to install the legacy Java SE 6 runtime”
>
> I updated all my packages, then I tried:
>       library(“rJava”)
> The outcome is the same.
>
> I installed Java (Java 8 Update 40), then tried again.  Same problem.  I can confirm that Java is installed:
>> PET633> java -version
>> java version "1.8.0_40"
>> Java(TM) SE Runtime Environment (build 1.8.0_40-b27)
>> Java HotSpot(TM) 64-Bit Server VM (build 25.40-b25, mixed mode)
>
> It appears that the rJava wants an old version of java — however, I can’t find that version at the Oracle website.  For curiosity, I tried to install Java SE 7 — the installer would not allow this once it found the newer version (8).  This suggests that installing version 6 will also not be permitted.
>
> Any thoughts?
>
> Dennis
>
> Dennis Fisher MD
> P < (The "P Less Than" Company)
> Phone: 1-866-PLessThan (1-866-753-7784)
> Fax: 1-866-PLessThan (1-866-753-7784)
> www.PLessThan.com
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac

________________________________


"Tenk miljø - vurder om du må skrive ut!"

"Consider the environment - consider whether you need to print!"