Re: Formatting in XLS(X) files
- To: mathgroup at smc.vnet.net
- Subject: [mg122086] Re: Formatting in XLS(X) files
- From: "andre.robin3" <andre.robin3 at wanadoo.fr>
- Date: Thu, 13 Oct 2011 03:47:10 -0400 (EDT)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- References: <j73gkt$fui$1@smc.vnet.net>
My solution to this problem was to export the file without formatting, and then call Excel from Mathematica via NETLink. Then I useVisual Basic instructions to control Excel. All this done programmaticaly in a very few lines of code (~20) but if you have to discover NETLink and Visual Basic, it is time consuming. "Josselin Noirel" <commercialat at jnoireldot.fr> a écrit dans le message de news: j73gkt$fui$1 at smc.vnet.net... > Dear all, > > I'm wondering if there's any way an XLS or XLSX file one exports can > get some nice formatting: bold face and/or background colour for some > of the cells? I'm compiling some results for collaborators and beyond > the numerical values, I'd like trends to be easily spotted by them. > >>From the examples, it looks like it's a definite NO unfortunately. > > Thanks very much, > > Joss > >