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]]
See: http://wiki.r-project.org/rwiki/doku.php?id=tips:data-io:ms_windows On Wed, Aug 5, 2009 at 11:56 AM, Inchallah Yarab<inchallahyarab at yahoo.fr> 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. > >
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
http://www.burns-stat.com
(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.
I recently downloaded an XLS file from a web site into a data.frame. You may want to try out the following:> ?install.packages(gdata) > library(gdata) > ?read.xlsMaura -----Messaggio originale----- Da: r-help-bounces@r-project.org per conto di Inchallah Yarab Inviato: mer 05/08/2009 17.56 A: r-help@r-project.org Oggetto: [R] how import Excel data into R? 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]] tutti i telefonini TIM! [[alternative HTML version deleted]]