Separating Columns in Excel Export from R
On 2012-07-27 09:30, watsonl wrote:
Hello - When I export my files using the write.table command and name the file.xls and use the sep="/t" to try and separate the columns in excel, everything just stays in one column. how do i get them all into separate columns (it did this before but i can't figure out what's different between this time exporting and other times when i enter the same thing)
You're _not_ entering the same thing! Wanna bet? (Hint: check you sep= argument) Peter Ehlers
example:
write.table(topTable(fit2, coef=3, adjust="fdr", sort.by="B",number=50000), file="preterm_parturient.xlsx", row.names=F, sep="/t")
what about this command wont let the columns get separated? -- View this message in context: http://r.789695.n4.nabble.com/Separating-Columns-in-Excel-Export-from-R-tp4638124.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at 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.