[R] Separating Columns in Excel Export from R

[John Kane]

I think you have a type: Try "\t"

John Kane
Kingston ON Canada


> -----Original Message-----
> From: watson.92 at hotmail.com
> Sent: Fri, 27 Jul 2012 09:30:34 -0700 (PDT)
> To: r-help at r-project.org
> Subject: [R] Separating Columns in Excel Export from R
> 
> 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)
> 
> 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.

____________________________________________________________
GET FREE SMILEYS FOR YOUR IM & EMAIL - Learn more at http://www.inbox.com/smileys
Works with AIM®, MSN® Messenger, Yahoo!® Messenger, ICQ®, Google Talk™ and most webmails