write.table to Excel file

How about using write.csv?
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.

Kazushige Shimpo<shimpo at fbc.keio.ac.jp>
Department of Business & Commerce
Keio University