[R] how import Excel data into R?

Patrick Burns pburns at pburns.seanet.com
Wed Aug 5 18:06:53 CEST 2009

I suspect that your problem is that
you didn't put in a second backslash to
escape the backslash in your path.
('The R Inferno' talks about backslashes
if this doesn't make sense to you.)

'The R Inferno' also would have said that
it was very good of you to show the actual
error message, but in addition translating
it into English would have been a plus.

A translation would be:
Impossible to open the connection

Patrick Burns
patrick at burns-stat.com
+44 (0)20 8525 0696
(home of "The R Inferno" and "A Guide for the Unwilling S User")

Inchallah Yarab wrote:
> Hi
> I want to import Excel data into R I have used this code 
> data<-read.table("C:\Total_Art_Policies.xls",header=TRUE,sep=";") 
> i have an error msg:
> Erreur dans file(file, "r") : impossible d'ouvrir la connexion 
> De plus : Warning message: 
> In file(file, "r") : 
> impossible d'ouvrir le fichier 'C:\Total_Art_Policies.xls' : No such file or directory 
> i tried to charge the package xlsreadwrite but i didn't found it?
> what i schould do someone can help me please?
> best regards
> 	[[alternative HTML version deleted]]
> ------------------------------------------------------------------------
> ______________________________________________
> 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.

More information about the R-help mailing list