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:lean...@cesgranrio.org.br] Sent: 05 November 2009 15:52 To: Hayes, Daniel; 'r-h...@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 ( lean...@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-boun...@r-project.org [mailto:r-help-boun...@r-project.org] Em nome de Hayes, Daniel Enviada em: quinta-feira, 5 de novembro de 2009 06:56 Para: 'r-h...@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@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.