help

[milly]

I need a code to export my output to excel 2007.I am dealing with observations of 15,000.Thank you

[PIKAL Petr]

Hi

write.table(tab, "clipboard", sep = "\t", row.names = FALSE)

or

write.table(tab, "somefile.xls", sep = "\t", row.names = FALSE)

Regards
Petr


[hidden email] napsal dne 13.08.2010 01:47:40:

>
> I need a code to export my output to excel 2007.I am dealing with
> observations of 15,000.Thank you
> --
> View this message in context:
http://r.789695.n4.nabble.com/help-tp2323542p2323542.html
> Sent from the Export many data to Excel 2007 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.

[Hans-Peter Suter]

or

library(xlsReadWrite)
write.xls(tab, "somefile.xls")  # not .xlsx

or  lots of other possibilities (e.g. RODBC, RExcel, gdata, WriteXLS)
you would have found searching the mailling list archive or looking in
the R import/export manual or the R wiki...

Cheers,
Hans-Peter

______________________________________________
[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.

[milly]

Please,when i export the output from R to excel.I am not getting all the 15,000 observations but only 2000.Thank you