[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