Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2008

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

Search the Archive

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


  • Prev by Date: Re: Unprotect[Pi]
  • Next by Date: Re: Mathematica in Education and Research
  • Previous by thread: Re: Export into Excel Worksheets
  • Next by thread: RE: Re: Export into Excel Worksheets