[R] collumn error when exporting to Excel

[Hayes, Daniel]

No luck with:
(col.names = NA and row.names = TRUE
Will check the other responses and else try to install writeXLS
Thanks for the help.
Daniel 

-----Original Message-----
From: Leandro Marino [mailto:leandro at cesgranrio.org.br] 
Sent: 05 November 2009 15:52
To: Hayes, Daniel; 'r-help at lists.R-project.org'
Subject: RES: [R] collumn error when exporting to Excel

Try using write.table(col.names = NA and row.names = TRUE) I don’t know if it will help you.

Another suggestion is to use the library writeXLS, is this library hava an function that exports your df into excel format.

Atenciosamente,
Leandro Lins Marino
Centro de Avaliação
Fundação CESGRANRIO
Rua Santa Alexandrina, 1011 - 2º andar
Rio de Janeiro, RJ - CEP: 20261-903
R (21) 2103-9600 R.:236 
  (21) 8777-7907
( leandro at cesgranrio.org.br

"Aquele que suporta o peso da sociedade
    é precisamente aquele que obtém
 as menores vantagens". (SMITH, Adam)

  Antes de imprimir pense em sua responsabilidade e compromisso com o MEIO AMBIENTE 

Esta mensagem, incluindo seus anexos, pode conter informacoes privilegiadas e/ou de carater confidencial, nao podendo ser retransmitida sem autorizacao do remetente. Se voce nao e o destinatario ou pessoa autorizada a recebe-la, informamos que o seu uso, divulgacao, copia ou arquivamento sao proibidos. 
Portanto, se você recebeu esta mensagem por engano, por favor, nos informe respondendo imediatamente a este e-mail e em seguida apague-a.

-----Mensagem original-----
De: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] Em nome de Hayes, Daniel
Enviada em: quinta-feira, 5 de novembro de 2009 06:56
Para: 'r-help at lists.R-project.org'
Assunto: [R] collumn error when exporting to Excel

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