Either make sure that perl is on your PATH or if the path/filename you specified is correct then try with backslashes just in case:
"C:\\perl\\bin\\perl.exe" Also check the upper/lower case of each component of your path just in case. On Thu, Oct 29, 2009 at 11:52 AM, tobiasfa <tobias.farnly...@gmail.com> wrote: > > This is what R says: > >> xls <- read.xls(file.choose()) > Converting xls file to csv file... Error in system(cmd, intern = !verbose) : > perl not found > Error in file.exists(tfn) : invalid 'file' argument >> xls <- read.xls(file.choose(), perl="C:/perl/bin/perl.exe") > Converting xls file to csv file... Error in system(cmd, intern = !verbose) : > perl not found > Error in file.exists(tfn) : invalid 'file' argument > > (I have installed Perl!) > > > Gabor Grothendieck wrote: >> >> If its already on your computer try one of these: >> >> xls <- read.xls("myfile.xls") # if its in current directory >> >> xls <- read.xls("/path/to/myfile.xls") # to specify path >> >> xls <- read.xls(file.choose()) # use explorer style interface to choose >> >> >> >> >> On Thu, Oct 29, 2009 at 9:36 AM, tobiasfa <tobias.farnly...@gmail.com> >> wrote: >>> >>> Using gdata on windows and im having trouble to retrieve an excel file >>> from a >>> folder on my computer. >>> >>> This is my dummy: >>> R > download.file("http://people.su.se/~lundh/data/cpi_kpix.rda", >>> + "cpi_kpix.rda") >>> >>> R > URL <- "http://people.su.se/" >>> R > PATH <- "~lundh/data/" >>> R > FILE <- "cpi_kpix.rda" >>> R > download.file(paste(URL,PATH,FILE,sep=""), >>> + "cpi_kpix.rda") >>> >>> R > library(gdata) >>> R > FILE <- "Stock_Returns_1931_2002.xls" >>> R > stock.xls <- read.xls(paste(URL, PATH, FILE, sep = ""), >>> + header = TRUE)[, 3:4] >>> Downloading... >>> Done. >>> Converting xls file to csv file... Done. >>> Reading csv file... Done. >>> >>> Im not suppose to download the file though its already on my computer. >>> How >>> do i type in the path så R finds my .xls?? >>> >>> kind regards Tobias >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Trouble-retrieving-data-%28.xls%29-from-folder-on-my-computer.-tp26113172p26113172.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-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. >> >> > > -- > View this message in context: > http://www.nabble.com/Trouble-retrieving-data-%28.xls%29-from-folder-on-my-computer.-tp26113172p26115725.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-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.