[R] write.table to Excel file

Kazushige Shimpo shimpo at fbc.keio.ac.jp
Fri Sep 1 03:57:48 CEST 2006


How about using write.csv?

Jeff Bricker wrote:
> 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.
>>
> 
> 
> ______________________________________________
> 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



More information about the R-help mailing list