Separating Columns in Excel Export from R

[watsonl]

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?

[John Kane]

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

John Kane
Kingston ON Canada

> -----Original Message-----
> From: [hidden email]
> Sent: Fri, 27 Jul 2012 09:30:34 -0700 (PDT)
> To: [hidden email]
> 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.
>
> ______________________________________________
> [hidden email] 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

______________________________________________
[hidden email] 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.

[Peter Ehlers]

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.
>
> ______________________________________________
> [hidden email] 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.
>

______________________________________________
[hidden email] 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.

[watsonl]

THANK YOU  

R is soooo picky :)

[John Kane]

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: [hidden email]
> Sent: Fri, 27 Jul 2012 12:13:30 -0700 (PDT)
> To: [hidden email]
> 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.
>
> ______________________________________________
> [hidden email] 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!

______________________________________________
[hidden email] 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.

[Bert Gunter]

See the Related Projects --> R GUI's -->IDE/Editors link on CRAN for a
fairly comprehensive list.

-- Bert

On Fri, Jul 27, 2012 at 4:43 PM, John Kane <[hidden email]> wrote:

> 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: [hidden email]
>> Sent: Fri, 27 Jul 2012 12:13:30 -0700 (PDT)
>> To: [hidden email]
>> 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.
>>
>> ______________________________________________
>> [hidden email] 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!
>
> ______________________________________________
> [hidden email] 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.

--

Bert Gunter
Genentech Nonclinical Biostatistics

Internal Contact Info:
Phone: [phone]
Website:
http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm

______________________________________________
[hidden email] 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.