[R] Odp: "easiest" way to write an R dataframe to excel?
Petr PIKAL
petr.pikal at precheza.cz
Tue Aug 24 08:52:25 CEST 2010
Hi
r-help-bounces at r-project.org napsal dne 23.08.2010 21:50:01:
> I am using R 2.11.1 in a Microsoft Windows 7 environment.
>
> I tried using WriteXLS, but get the message " In system(cmd) : perl not
found"
>
> What is the "easiest" way to write an R dataframe to Excel? (I am
familiar with
> WriteXLS, but I do not have PERL installed, and if not needed, do not
wish to
> install it.)
>
> I am also familiar with write.table, but if possible, wish to create an
excel
> file form within R.
How big is your table
If it fit to clipboard you can
write.table(some.data.frame, "clipboard", sep="\t", row.names=FALSE)
and press CTRL-C in Excel
If not you can
write.table(some.data.frame, "mytable.xls", sep="\t", row.names=FALSE)
and the table is readable by Excel
Regards
Petr
>
> I'm unsure if this is possible, or perhaps i should just go ahead and
install
> PERL...?
>
>
>
> [[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.
More information about the R-help
mailing list