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

[Gabor Grothendieck]

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