[R] Writing a data frame in an excel file

David Winsemius dwinsemius at comcast.net
Mon Nov 16 21:19:18 CET 2009


On Nov 16, 2009, at 3:13 PM, David Winsemius wrote:

>
> On Nov 16, 2009, at 3:06 PM, smu wrote:
>
>> hello,
>>
>> sep="\n" will seperate each column by \n which is not what you want.
>>
>> I think a csv would be the best solution.
>>
>> write.table(yourdataframe,sep=",")
>
> Excel will also read (and even prefers in some sense) tab delimited  
> files, so:
>
> write.table(yourdataframe, file="dataout.xls", sep="\t")

Neither one of those methods will deal with the problem that no  
separator is put in the file on the first row before the colnames. To  
keep the names registered with the columns you would need to set  
row.names=F

write.table(yourdataframe, file="dataout.xls", sep="\t",  
row.names=FALSE)

-- 
David.


>
>
>
>> or use write.csv directly.
>>
>> regards,
>> stefan
>>
>> On Mon, Nov 16, 2009 at 11:49:28AM -0800, anna_l wrote:
>>>
>>> Hello, I am having trouble by using the write.table function to  
>>> write a data
>>> frame of 4 columns and 7530 rows. I don´t  know if I should just  
>>> use a
>>> sep="\n" and change the .xls file into a .csv file. Thanks in  
>>> advance
>>>
>>> -----
>>> Anna Lippel
> -- 
>>



More information about the R-help mailing list