[R] R data Export to Excel

[Wensui Liu]

hi,
did you try write.xls in xlsReadWrite package?


On Sun, Mar 2, 2008 at 9:59 PM, Keizer_71 <christophe.lo at gmail.com> wrote:
>
>  Here is my R Code
>
>  x<-1:20000
>  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,var)),file='c://variance.csv')
>  #export as a .csv file.
>
>  Output in Excel
>  all in 1 column.
>
>  ProbeID "Variance"
>  1 "224588_at" 21.5825745738848
>
>  How do i separate them so that i can have three columns
>
>      ProbeID      Variance
>  1   224588_at   21.582.....
>
>  thanks,
>  Kei
>
>
>  --
>  View this message in context: http://www.nabble.com/R-data-Export-to-Excel-tp15796903p15796903.html
>  Sent from the R help mailing list archive at Nabble.com.
>
>  ______________________________________________
>  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.
>



-- 
===============================
WenSui Liu
ChoicePoint Precision Marketing
Phone: 678-893-9457
Email : wensui.liu at choicepoint.com
Blog   : statcompute.spaces.live.com