MathGroup Archive 2005

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

Search the Archive

Re: Export[] to XLS

  • To: mathgroup at smc.vnet.net
  • Subject: [mg62380] Re: [mg62337] Export[] to XLS
  • From: ggroup at sarj.ca
  • Date: Tue, 22 Nov 2005 04:42:36 -0500 (EST)
  • References: <20051121114855.JTPP8508.eastrmmtao02.cox.net@[172.18.52.8]>
  • Reply-to: ggroup at sarj.ca
  • Sender: owner-wri-mathgroup at wolfram.com

Hi Bob,

On Monday, November 21, 2005 at 6:49 GMT -0500, Bob Hanlon wrote:

> One way would be to import the intended sheet name into the first cell of 
> each sheet and add the following macro to the code module of the workbook 
> or an add-on.  Manually run the macro or put a call to it in an Auto_Open 
> macro.

Thanks for the suggestion.  Unfortunately, the export routine appears
to be limited to handling very regular tables (like an L by M by N
table), so you need to play a few (albeit minor) tricks to get the M
by N tables to export correctly.

I was hoping for something more automated if it's reasonably easy and
from Mathematica*. Ultimately, I don't want to invest too much time
on this since I would prefer to spend the time finding ways of making
the current need for Excel redundant.

* For example, adding column headings for each table is as simple as:
  Append[#, {"Heading 1", "Heading 2", ..., "Heading M"}]& /@ data





  • Prev by Date: Re: Re: Confusing results with N[expr]?
  • Next by Date: Re: How to read a data file in text format?_from a new learner
  • Previous by thread: Export[] to XLS
  • Next by thread: Re: Export[] to XLS