An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121203/4d251f88/attachment.pl>
xlsx file read in R
9 messages · Nico Met, Gabor Grothendieck, Uwe Ligges +4 more
On Mon, Dec 3, 2012 at 7:59 AM, Nico Met <nicomet80 at 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
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 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.
http://cran.r-project.org/doc/manuals/R-data.html John Kane Kingston ON Canada
-----Original Message----- From: nicomet80 at gmail.com Sent: Mon, 3 Dec 2012 13:59:18 +0100 To: r-help at 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 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.
____________________________________________________________ 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
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 <nicomet80 at gmail.com> wrote:
Dear all,
How can I read .xlsx files in R
Regards Nico
[[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.
use the XLConnect package.
On Mon, Dec 3, 2012 at 7:59 AM, Nico Met <nicomet80 at gmail.com> wrote:
Dear all,
How can I read .xlsx files in R
Regards Nico
[[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.
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.
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121203/9a051a00/attachment.pl>
On Mon, Dec 3, 2012 at 1:27 PM, Nico Met <nicomet80 at 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
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.