[R] Xlsx and R -read problem
Hi, I have an excel 2007 file located in C:\know and called try.xlsx. Whan I try to read it I get this error: file - system.file(know, try.xlsx, package = xlsx) res - read.xlsx(file, 2) # read the second sheet Error in .jnew(java/io/FileInputStream, file) : java.io.FileNotFoundException: Can someone tell me what is the problem? and how to solve it. Cheers, Ashz -- View this message in context: http://r.789695.n4.nabble.com/Xlsx-and-R-read-problem-tp2998304p2998304.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.
Re: [R] Xlsx and R -read problem
try library(RODBC) and odbcConnectExcel2007; it has worked for me. On Sat, Oct 16, 2010 at 10:17 AM, ashz a...@walla.co.il wrote: Hi, I have an excel 2007 file located in C:\know and called try.xlsx. Whan I try to read it I get this error: file - system.file(know, try.xlsx, package = xlsx) res - read.xlsx(file, 2) # read the second sheet Error in .jnew(java/io/FileInputStream, file) : java.io.FileNotFoundException: Can someone tell me what is the problem? and how to solve it. Cheers, Ashz -- View this message in context: http://r.789695.n4.nabble.com/Xlsx-and-R-read-problem-tp2998304p2998304.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. -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? __ 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 and R -read problem
On Sat, Oct 16, 2010 at 10:17 AM, ashz a...@walla.co.il wrote: Hi, I have an excel 2007 file located in C:\know and called try.xlsx. Whan I try to read it I get this error: file - system.file(know, try.xlsx, package = xlsx) res - read.xlsx(file, 2) # read the second sheet Error in .jnew(java/io/FileInputStream, file) : java.io.FileNotFoundException: Try: File - file.path(c:, know, try.xlsx); File res - read.xlsx(File, 2) or setwd(c:/know) res - read.xlsx(try.xlsx, 2) -- 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.