[R] Trouble retrieving data (.xls) from folder on my computer.

[tobiasfa]

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.farnlycke at 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 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.
>>
> 
> ______________________________________________
> 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.
> 
> 

-- 
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.