I took the subset of the data you send, did a 'write.csv' and then imported it to Excel and the columns seem fine (see the .png file attached).
So exactly what problems are you having? On Thu, Nov 5, 2009 at 12:49 PM, Hayes, Daniel <d.j.ha...@liverpool.ac.uk> wrote: > No luck with 'write.csv' either. > Thanks for helping though. > Cheers, > Daniel > > -----Original Message----- > From: jim holtman [mailto:jholt...@gmail.com] > Sent: 05 November 2009 14:59 > To: Hayes, Daniel > Cc: r-h...@lists.r-project.org > Subject: Re: [R] collumn error when exporting to Excel > > 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? > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?
<<attachment: jph.png>>
______________________________________________ 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.
