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