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
______________________________________________
[email protected] 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.
