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 <[EMAIL PROTECTED]> 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@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.
>
______________________________________________
R-help@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.
