Re: [R] i want to export a data.frame to file.xls

From: Jorge Ivan Velez <jorgeivanvelez_at_gmail.com>
Date: Mon, 19 May 2008 15:59:57 -0400

Hi Hanen,
Take a look at ?write.table. Also, try this:

write.table(df,"file_name.xls",col.names=FALSE,row.names=FALSE,sep="\t")

or

write.table(df,"file_name.xls",sep="\t")

HTH, Jorge

On Mon, May 19, 2008 at 3:27 PM, hanen <hanen.mastouri_at_yahoo.fr> wrote:

>
> in order to export a data.frame to sheet.xls i try:
>
> write(df,file="file_name.xls")
>
> but when i open it a message appears:
>
> "impossible to oppen this file. her format is unvalid"
>
> knowen that i work with excel_2007
>
> what is the solution ?
> --
> View this message in context:
> http://www.nabble.com/i-want-to-export-a-data.frame-to-file.xls-tp17326119p17326119.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.
>

        [[alternative HTML version deleted]]



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 19 May 2008 - 20:04:28 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 19 May 2008 - 20:30:48 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