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

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
>
>