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: email@example.com
- References: <firstname.lastname@example.org> <email@example.com>
"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.