Separating Columns in Excel Export from R

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

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.

-----Original Message-----
From: watson.92 at hotmail.com
Sent: Fri, 27 Jul 2012 12:13:30 -0700 (PDT)
To: r-help at r-project.org
Subject: Re: [R] Separating Columns in Excel Export from R

THANK YOU

R is soooo picky :)



--
View this message in context:
http://r.789695.n4.nabble.com/Separating-Columns-in-Excel-Export-from-R-tp4638124p4638147.html
Sent from the R help mailing list archive at Nabble.com.

Yes just a bit picky.  While it would not have caught this problem a good editor with highlighting (Tinn-R in Windows, gedit or geany? in Linux can really help.

Try googling for a discusson of editors for R.  There was one a few month ago I think

John Kane
Kingston ON Canada

-----Original Message-----
From: watson.92 at hotmail.com
Sent: Fri, 27 Jul 2012 12:13:30 -0700 (PDT)
To: r-help at r-project.org
Subject: Re: [R] Separating Columns in Excel Export from R

THANK YOU

R is soooo picky :)



--
View this message in context:
http://r.789695.n4.nabble.com/Separating-Columns-in-Excel-Export-from-R-tp4638124p4638147.html
Sent from the R help mailing list archive at Nabble.com.