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