Re: [R] Xlsx and R -read problem

2010-10-16 Thread Gabor Grothendieck
On Sat, Oct 16, 2010 at 10:17 AM, ashz 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 .j

Re: [R] Xlsx and R -read problem

2010-10-16 Thread jim holtman
try library(RODBC) and odbcConnectExcel2007; it has worked for me. On Sat, Oct 16, 2010 at 10:17 AM, ashz 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")

[R] Xlsx and R -read problem

2010-10-16 Thread ashz
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.FileNotFo