[R] write.table to Excel file

array chip arrayprofile at yahoo.com
Fri Sep 1 02:21:59 CEST 2006


Hi, I found that when writing a matrix with row names
and column names to an Excel file, the Excel file when
opened has column names shifted towards left resulting
disalignment. Here is an exmaple

x<-matrix(1:20,nrow=4,dimnames=list(paste('r',1:4,sep=''),paste('c',1:5,sep='')))
write.table(x,"xx.xls",sep='\t')

If you open the xx.xls file, you will understand what
I meant. Is there anyway to solve the disalignment?

Thanks



More information about the R-help mailing list