Re: [R] R data Export to Excel

2008-03-03 Thread Gavin Simpson
The other respondants here have missed the point - write.table() as invoked by the OP does not produce a csv file. The default separator is " " (a space) in write.table(), so no wonder Excel cocked it up as it assumes that a csv file is one that has elements separated by a comma ",". We don't need

Re: [R] R data Export to Excel

2008-03-02 Thread Hans-Peter
> > it doesn't seem indicate any installation instruction. > http://cran.r-project.org/web/packages/xlsReadWrite/index.html As Wensui Liu already mentioned, installation is the same as with other packages: In the RGui menu select Packages->Install Packages...->(Select a CRAN mirror)->(Select the

Re: [R] R data Export to Excel

2008-03-02 Thread Wensui Liu
i think you simply install it in the way you install other R packages. On Sun, Mar 2, 2008 at 10:40 PM, Christophe Lo <[EMAIL PROTECTED]> wrote: > thanks for your response. How do i install it? I try looking at the manual > it doesn't seem indicate any installation instruction. I also download a >

Re: [R] R data Export to Excel

2008-03-02 Thread Christophe Lo
thanks for your response. How do i install it? I try looking at the manual it doesn't seem indicate any installation instruction. I also download a windows version but it doesn't have an exe file. http://cran.r-project.org/web/packages/xlsReadWrite/index.html Newbie, Kei On 3/3/08, Wensui Liu <

Re: [R] R data Export to Excel

2008-03-02 Thread Wensui Liu
hi, did you try write.xls in xlsReadWrite package? On Sun, Mar 2, 2008 at 9:59 PM, Keizer_71 <[EMAIL PROTECTED]> wrote: > > Here is my R Code > > x<-1:2 > y<-2:141 > data.matrix<-data.matrix(data[,y])#create data.matrix > variableprobe<-apply(data.matrix[x,],1,var) > variableprobe #outp

Re: [R] R data Export to Excel

2008-03-02 Thread jim holtman
If you are asking how to convert to multiple columns in Excel, look at the "text to column" option in I think the data tab. On Sun, Mar 2, 2008 at 9:59 PM, Keizer_71 <[EMAIL PROTECTED]> wrote: > > Here is my R Code > > x<-1:2 > y<-2:141 > data.matrix<-data.matrix(data[,y])#create data.matrix >

[R] R data Export to Excel

2008-03-02 Thread Keizer_71
Here is my R Code x<-1:2 y<-2:141 data.matrix<-data.matrix(data[,y])#create data.matrix variableprobe<-apply(data.matrix[x,],1,var) variableprobe #output variance across probesets hist(variableprobe) #displaying histogram of variableprobe write.table(cbind(data[1], Variance=apply(data[,y],1,