[R] IMPORTING FILE FROM EXCEL

Lanre Okusanya lanre.okusanya at gmail.com
Tue Jul 4 12:24:40 CEST 2006


try

read.table('C:\\Documents and Settings\\stats\\Desktop\\SUMI\\plasma2.txt')
for file.show, it is the same except note the slashes.

On 7/4/06, Jacques VESLOT <jacques.veslot at good.ibl.fr> wrote:
> if you don't need to import several dataset, you can directly change current
> directory from the file
> menu and move to your working directory instead of substuting all
> backslashes for slashes in import
> function argument.
> you can also copy your dataset in excel and do :
>  > data1 <- read.delim("clipboard")
> -------------------------------------------------------------------
> Jacques VESLOT
>
> CNRS UMR 8090
> I.B.L (2ème étage)
> 1 rue du Professeur Calmette
> B.P. 245
> 59019 Lille Cedex
>
> Tel : 33 (0)3.20.87.10.44
> Fax : 33 (0)3.20.87.10.31
>
> http://www-good.ibl.fr
> -------------------------------------------------------------------
>
>
> Rashmi Pant a écrit :
> > Hi
> >   I am a beginner with R.
> >   I have been trying to import a tab delimited excel file but i get the
> following error message
> >   > file.show('C:\Documents and Settings\stats\Desktop\SUMI\plasma2.txt')
> > Warning message:
> > file.show(): file 'C:Documents and SettingsstatsDesktopSUMIplasma2.txt'
> does not exist
> >  I have understood the programming part but i cannot go ahead unless i
> have imported the file. I have consulted the R-help archive without success.
> >   Any help will be appreciated
> >   Thanks in advance
> >
> >  		
> > ---------------------------------
> >
> > 	[[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
> >
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>



More information about the R-help mailing list