Re: [R] xlsx file read in R

2012-12-04 Thread Martin Studer
Hi Nico, please let me know the details of sessionInfo() in R. Also, what version of Java are you running? If you could post the output of "java -version" from the command line that would be great. Note that XLConnect requires at least Java 1.6. Best regards, Martin -- View this message in co

Re: [R] xlsx file read in R

2012-12-03 Thread R. Michael Weylandt
On Mon, Dec 3, 2012 at 1:27 PM, Nico Met wrote: > Dear all, > > this is the code I used to read the .xlsx file but get an error message > > library(rJava) > library(XLConnectJars) > library(XLConnect) > file<-readWorksheetFromFile("all_in.xlsx", sheet = 1) > > Error: NoClassDefFoundError (J

Re: [R] xlsx file read in R

2012-12-03 Thread Nico Met
Dear all, this is the code I used to read the .xlsx file but get an error message library(rJava) library(XLConnectJars) library(XLConnect) file<-readWorksheetFromFile("all_in.xlsx", sheet = 1) *Error: NoClassDefFoundError (Java): Could not initialize class org.apache.poi.POIXMLDocument*

Re: [R] xlsx file read in R

2012-12-03 Thread jim holtman
use the XLConnect package. On Mon, Dec 3, 2012 at 7:59 AM, Nico Met wrote: > Dear all, > > How can I read .xlsx files in R > > Regards Nico > > [[alternative HTML version deleted]] > > __ > R-help@r-project.org mailing list > https://stat.ethz.c

Re: [R] xlsx file read in R

2012-12-03 Thread R. Michael Weylandt
There are a couple of CRAN packages available -- my personal recommendation is XLConnect. MW On Mon, Dec 3, 2012 at 12:59 PM, Nico Met wrote: > Dear all, > > How can I read .xlsx files in R > > Regards Nico > > [[alternative HTML version deleted]] > >

Re: [R] xlsx file read in R

2012-12-03 Thread John Kane
http://cran.r-project.org/doc/manuals/R-data.html John Kane Kingston ON Canada > -Original Message- > From: nicome...@gmail.com > Sent: Mon, 3 Dec 2012 13:59:18 +0100 > To: r-help@r-project.org > Subject: [R] xlsx file read in R > > Dear all, > > How

Re: [R] xlsx file read in R

2012-12-03 Thread Uwe Ligges
On 03.12.2012 13:59, Nico Met wrote: Dear all, How can I read .xlsx files in R See the Data Import/Export manual? Uwe Ligges Regards Nico [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/

Re: [R] xlsx file read in R

2012-12-03 Thread Gabor Grothendieck
On Mon, Dec 3, 2012 at 7:59 AM, Nico Met wrote: > Dear all, > > How can I read .xlsx files in R > See: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ___

[R] xlsx file read in R

2012-12-03 Thread Nico Met
Dear all, How can I read .xlsx files in R Regards Nico [[alternative HTML version deleted]] __ R-help@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-gui