R help - Oct 2005 - write.table call

Hi,

I use write.table() to write a file to an external xls file. the column names
left-shift one position in output file. I check with col.names() row.names(),
the file is fine. How to prevent the shifting?

I71	I111	I304	I307	I305	I306	I114	I72		
AFFX-BioB-5_at	6.66435	6.787807	5.335962	5.250163	6.47423	5.882104	5.965109
6.591687195
AFFX-BioB-M_at	6.163227	5.965427	4.665569	2.743531	6.097244	5.77137	5.113683
6.314003982

Thanks,
Johnny

	[[alternative HTML version deleted]]

RTFM, in particular the "CSV Files" section of ?write.table.

BTW, R itself does not write "xls" files.

Andy
> From: Li,Qinghong,ST.LOUIS,Molecular Biology
> 
> Hi,
> 
> I use write.table() to write a file to an external xls file. 
> the column names left-shift one position in output file. I 
> check with col.names() row.names(), the file is fine. How to 
> prevent the shifting? 
> 
> I71	I111	I304	I307	I305	I306	I114	I72		
> AFFX-BioB-5_at	6.66435	6.787807	5.335962	
> 5.250163	6.47423	5.882104	5.965109	6.591687195	
> AFFX-BioB-M_at	6.163227	5.965427	
> 4.665569	2.743531	6.097244	5.77137	
> 5.113683	6.314003982	
> 
> Thanks,
> Johnny
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> 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
> 
>