MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

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




  • Prev by Date: Ticks without labels
  • Next by Date: Clear all variables but not functions
  • Previous by thread: Export list to Excel without brackets
  • Next by thread: Re: Export list to Excel without brackets