[R] collumn error when exporting to Excel

jim holtman jholtman at gmail.com
Thu Nov 5 21:11:19 CET 2009


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.Hayes at liverpool.ac.uk> wrote:
> No luck with 'write.csv' either.
> Thanks for helping though.
> Cheers,
> Daniel
>
> -----Original Message-----
> From: jim holtman [mailto:jholtman at gmail.com]
> Sent: 05 November 2009 14:59
> To: Hayes, Daniel
> Cc: r-help at 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.Hayes at 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 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.
>>
>
>
>
> --
> 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?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jph.png
Type: image/png
Size: 13067 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20091105/790aacdb/attachment-0002.png>


More information about the R-help mailing list