Or use
write.table(object, "clipboard", sep="\t", row.names=F)
and press Ctrl V in empty excell sheet.
Regards
Petr
r-help-boun...@r-project.org napsal dne 05.11.2009 14:59:19:
> try using 'write.csv' to create the file you want to import to EXCEL
>
> On Thu, Nov 5, 2009 at 4:56 AM, Hayes, Daniel
<d.j.ha...@liverpool.ac.uk> wrote:
> > Dear all,
> >
> > I am attempting to export my results (data.frame) created with the
help of a
> number of you to Excel.
> > In the procedure my column structure is however lost and all results
are
> placed together into the first Excel column.
> > I have tried: write(), write.table(), write.matrix(), export() and
have the
> same results. I Have checked the import/export FAQ and did a Google
search to no avail.
> > Any advice would be greatly appreciated.
> >
> > Kind greetings,
> > Daniel
> >
> >> dput(Bolivia.selected.ms.lat.m[1:10,])
> > structure(list(age = c(0, 0.0833333333333333, 0.166666666666667,
> > 0.25, 0.333333333333333, 0.416666666666667, 0.5, 0.583333333333333,
> > 0.666666666666667, 0.75), country = structure(c(1L, 1L, 1L, 1L,
> > 1L, 1L, 1L, 1L, 1L, 1L), .Label = c("Bolivia", "Brazil", "Colombia",
> > "Dominican Rep.", "El Salvador", "Guatemala", "Guyana", "Haiti",
> > "Honduras", "Nicaragua", "Paraguay", "Peru", "Suriname"), class =
"factor"),
> > mu = c(11.4216795790532, 11.336249852927, 11.2841715916567,
> > 11.2112464680493, 11.1163747056146, 11.0042010015542,
10.8814601111044,
> > 10.7555483953614, 10.6326412246687, 10.5168465177670), sigma =
c(0.101487190832973,
> > 0.105383747354763, 0.107059434066487, 0.108387198864101,
> > 0.109530496229634, 0.110541869698550, 0.111444696116090,
> > 0.112248590819971, 0.112951348056450, 0.113550216614654)), .Names =
c("age",
> > "country", "mu", "sigma"), row.names = c("1", "2", "3", "4",
> > "5", "6", "7", "8", "9", "10"), class = "data.frame")
> >> write.matrix(Bolivia.selected.ms.lat.m, file="C:\\Documents and
Settings\
> \Dohyedan\\My Documents\\bolivia.selected.ms.lat.m", sep=" ")
> >>
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help@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.
> >
>
>
>
> --
> Jim Holtman
> Cincinnati, OH
> +1 513 646 9390
>
> What is the problem that you are trying to solve?
>
> ______________________________________________
> R-help@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@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.
