Skip to content
Prev 199247 / 398506 Next

collumn error when exporting to Excel

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
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")
______________________________________________
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.
Message-ID: <13F170DB286EED4EB140B291F2148AD9534C66DF59@STAFFMBX1.livad.liv.ac.uk>
In-Reply-To: <!&!AAAAAAAAAAAYAAAAAAAAAEadxqYXQLlLmuUnwe+aKQfCgAAAEAAAAPlV3/QH/spGrWx/571Jrk4BAAAAAA==@cesgranrio.org.br>