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.