Re: [R] Excel export into R

2008-03-06 Thread Alberto Monteiro
Keizer_71 wrote: > > I have this in excel > > Control > 543_BU > 123_AT > 432_CU > > I want to be able to import to R so that it will read like this > > c<-c("543_BU","123_AT","432_CU") > > output: > [1] "543_BU" "123_AT" "432_CU" > > This is just a short version. I have about 20 rows and

Re: [R] Excel export into R

2008-03-06 Thread Keizer_71
Hi Richie, I apologize. I thought i deleted this thread since it is resolved by using scan() function. thank you again, Kei Richard Cotton wrote: > >> I have this in excel >> >> Control >> 543_BU >> 123_AT >> 432_CU >> >> >> I want to be able to import to R so that it will read like this >

Re: [R] Excel export into R

2008-03-06 Thread Richard . Cotton
> I have this in excel > > Control > 543_BU > 123_AT > 432_CU > > > I want to be able to import to R so that it will read like this > > c<-c("543_BU","123_AT","432_CU") See the help page for read.csv ?read.csv ...and the R Data Import/Export manual http://cran.r-project.org/doc/manuals/R-data

Re: [R] Excel export into R

2008-03-05 Thread jim holtman
There are a number of ways for importing from EXCEL. For example if you were to create a CSV file for EXCEL, you can read it like: > x <- read.table('/tempxx.txt.r', header=TRUE, as.is=TRUE) > x Control 1 543_BU 2 123_AT 3 432_CU On Wed, Mar 5, 2008 at 6:42 PM, Keizer_71 <[EMAIL PROTECTED]

[R] Excel export into R

2008-03-05 Thread Keizer_71
Hello, I have this in excel Control 543_BU 123_AT 432_CU I want to be able to import to R so that it will read like this c<-c("543_BU","123_AT","432_CU") output: [1] "543_BU" "123_AT" "432_CU" This is just a short version. I have about 20 rows and i need a simpler way instead of typing