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.
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
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. >
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. > > ______________________________________________ > 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.____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!