Re: Export into Excel Worksheets
- To: mathgroup at smc.vnet.net
- Subject: [mg90864] Re: [mg90811] Export into Excel Worksheets
- From: Andy Anderson <aanderson at amherst.edu>
- Date: Sat, 26 Jul 2008 04:24:36 -0400 (EDT)
- References: <200807251013.GAA11988@smc.vnet.net>
On Jul 25, 2008, at 6:13 AM, Coleman, Mark wrote:
> I've got a list of data that I'd like to Export into Excel. The twist
> is, I'd like to export each element of the list into a separate
> worksheet within the same Excel Workbook. Can this be done in
> Mathematica v6?
v6 docs say "Import and Export by default use the "Data" element.",
and "Data ... [is a] list of full arrays, representing all sheets".
So the answer is yes, confirmed by my testing. Specifically, a tensor
with dimension S x R x C will be saved into S sheets with R rows and
C columns. For example,
In:= a = Table[Random[], {4}, {3}, {2}]
Out= {
{{0.196065, 0.0107993}, {0.0621981, 0.149353}, {0.489958, 0.740329}},
{{0.236605, 0.662268}, {0.64053, 0.553502}, {0.915333,
0.741054}},
{{0.856358, 0.347337}, {0.831542, 0.126143}, {0.253758,
0.206718}},
{{0.693209, 0.839594}, {0.331732, 0.39102}, {0.416769,
0.630923}}
}
In:= Export["test.xls", a]
will produce the file "test.xls" with four sheets, each containing
one of the lines above in a 3 x 2 cell range.
-- Andy
- References:
- Export into Excel Worksheets
- From: "Coleman, Mark" <Mark.Coleman@LibertyMutual.com>
- Export into Excel Worksheets