Re: Export list to Excel without brackets
- To: mathgroup at smc.vnet.net
- Subject: [mg122180] Re: Export list to Excel without brackets
- From: Bill Rowe <readnews at sbcglobal.net>
- Date: Wed, 19 Oct 2011 05:34:34 -0400 (EDT)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
On 10/18/11 at 7:41 AM, paulvonhippel at yahoo.com (paul) wrote:
>Like a previous poster, I would like to export a list to Excel. Here
>is my list:
>{{{1.27,1.12,1.00,0.90,0.83},{0.27,0.12,0.00,-0.10,-0.17},
>{0.66,0.56,0.49,0.43,0.38},{0.72,0.57,0.49,0.44,0.42}},
>{{1.09,1.03,0.97,0.93,0.89},{0.09,0.03,-0.03,-0.07,-0.11},
>{0.27,0.25,0.23,0.21,0.20},{0.29,0.25,0.23,0.22,0.23}}}
>I would like it to arrive in Excel in this layout:
>1.27 0.27 0.66 0.72
>1.12 0.12 0.56 0.57
>1.00 0.00 0.49 0.49
>0.90 -0.10 0.43 0.44
>0.83 -0.17 0.38 0.42
>1.09 0.09 0.27 0.29
>1.03 0.03 0.25 0.25
>0.97 -0.03 0.23 0.23
>0.93 -0.07 0.21 0.22
>0.89 -0.11 0.20 0.23
Try
Export[filename,
Join[data[[1]], {Table["", {Length@data[[1, 1]]}]}, data[[2]]],
"XLS"]
where data is the nested list of values you posted