[R] Xlsx and R -read problem
jim holtman
jholtman at gmail.com
Sat Oct 16 20:47:21 CEST 2010
try library(RODBC) and odbcConnectExcel2007; it has worked for me.
On Sat, Oct 16, 2010 at 10:17 AM, ashz <ashz at 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 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
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
More information about the R-help
mailing list