Re: Export into Excel Worksheets
- To: mathgroup at smc.vnet.net
- Subject: [mg90866] Re: Export into Excel Worksheets
- From: Jean-Marc Gulliet <jeanmarc.gulliet at gmail.com>
- Date: Sat, 26 Jul 2008 04:25:00 -0400 (EDT)
- Organization: The Open University, Milton Keynes, UK
- References: <g6c961$bpv$1@smc.vnet.net>
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?
Assuming that you mean that you have a list of lists of lists,
Mathematica 6.0 will automatically save each list of lists in a separate
sheet within the same worksheet. For instance, try the following
data = RandomReal[{0, 1}, {3, 4, 2}];
Export["test.xls", data]
Regards,
-- Jean-Marc