Re: [R] xlsx file read in R
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 context: http://r.789695.n4.nabble.com/xlsx-file-read-in-R-tp4651829p4652003.html Sent from the R help mailing list archive at Nabble.com. __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] xlsx file read in R
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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
On Mon, Dec 3, 2012 at 7:59 AM, Nico Met nicome...@gmail.com 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-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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
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/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. __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
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 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-guide.html and provide commented, minimal, self-contained, reproducible code. GET FREE SMILEYS FOR YOUR IM EMAIL - Learn more at http://www.inbox.com/smileys Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
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 nicome...@gmail.com 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.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. __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
use the XLConnect package. On Mon, Dec 3, 2012 at 7:59 AM, Nico Met nicome...@gmail.com 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.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. -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
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* No idea where it went wrong Regards Nico On Mon, Dec 3, 2012 at 2:07 PM, jim holtman jholt...@gmail.com wrote: use the XLConnect package. On Mon, Dec 3, 2012 at 7:59 AM, Nico Met nicome...@gmail.com 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.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. -- Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. [[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-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] xlsx file read in R
On Mon, Dec 3, 2012 at 1:27 PM, Nico Met nicome...@gmail.com 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 (Java): Could not initialize class org.apache.poi.POIXMLDocument No idea where it went wrong Regards Nico Can you run the examples from some of the package help pages or is the whole thing not working? Michael __ 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-guide.html and provide commented, minimal, self-contained, reproducible code.