Writing a data frame in an excel file
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