[R] write.table to Excel file

[Jeff Bricker]

from ?write.table:

     By default there is no column name for a column of row names.  If
     'col.names = NA' and 'row.names = TRUE' a blank column name is
     added, which is the convention for CSV files to be read by
     spreadsheets.


On 8/31/06, array chip <arrayprofile at yahoo.com> wrote:
> 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
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>