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

Re: Formatting in XLS(X) files

• To: mathgroup at smc.vnet.net
• Subject: [mg122461] Re: Formatting in XLS(X) files
• From: "andre.robin3" <andre.robin3 at wanadoo.fr>
• Date: Sat, 29 Oct 2011 07:10:50 -0400 (EDT)
• Delivered-to: l-mathgroup@mail-archive0.wolfram.com
• References: <j73gkt$fui$1@smc.vnet.net> <j8dtgo$kg1$1@smc.vnet.net>

"Josselin Noirel" <commercialat at jnoireldot.fr> a écrit dans le message de 
news: j8dtgo$kg1$1 at smc.vnet.net...
> On 2011-10-12 07:46:37 +0000, Josselin Noirel said:
>
>> 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.
>
> Thanks everyone for answering (and sorry for the very late reply).  Not
> so easy then, I got really frustrated with Excel about it.
>
> NETLink could be the way forward, however I suspect that it won't work
> on a MacBook.
>
> Excel 2011 for Mac seems to have Visual Basic.
>
> Either VBA on Excel 2011: 1. I need to get Excel 2011, 2. I need to
> learn VBA (again) and its functions for formatting
>
> I learn NETLink and run the Mathematica code on a Windows machine.
>
> NETLink looks like a better option.  I'll look in to that.  Thanks again!
>
> Joss
>
>

I don't understand very well the meaning of theses sentences.
May be it is important to mention that I have used Excel 2000 on Windows XP.