[R] Writing a data frame in an excel file

David Winsemius dwinsemius at comcast.net
Mon Nov 16 21:13:44 CET 2009


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")



> 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
-- 
>

David Winsemius, MD
Heritage Laboratories
West Hartford, CT




More information about the R-help mailing list