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

______________________________________________
R-help@r-project.org 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.

Reply via email to