[R] Odp: Newbie:Export Data into Excel from R

From: Petr PIKAL <petr.pikal_at_precheza.cz>
Date: Mon, 03 Mar 2008 11:53:21 +0100

Hi

you can also

write.table(probe_gene, file = "c:/foo.xls", sep = "\t", col.names = NA)

or

write.table(tab, "clipboard", sep = "\t" , col.names = NA)

and after opening Excel just press Ctrl-V. Maybe you also find usefull to add row.names=FALSE into export construction.

Petr
petr.pikal_at_precheza.cz

r-help-bounces_at_r-project.org napsal dne 02.03.2008 16:12:51:

>
> Hi,
>
> All i want is to export my list into c: drive and save it as csv file
and
> manually import into Excel.
>
> I have the read the article but i am having issues
> http://pbil.univ-lyon1.fr/library/base/html/write.table.html
>
>
> > excel<-write.table(probe_gene, file = "c:\foo.csv", sep = ",",
col.names =
> > NA)
> Error in file(file, ifelse(append, "a", "w")) :
>
> unable to open connection
> In addition: Warning message:
> cannot open file 'c:\foo.csv', reason 'Invalid argument'
>
> any suggestions?
>
> thanks,
> chris
>
>
> --
> View this message in context:
http://www.nabble.com/Newbie%3AExport-Data-into-
> Excel-from-R-tp15788950p15788950.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.



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. Received on Mon 03 Mar 2008 - 11:00:24 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 03 Mar 2008 - 11:30:18 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive