MathGroup Archive 2011

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

Search the Archive

Re: Formatting in XLS(X) files

  • To: mathgroup at
  • Subject: [mg122086] Re: Formatting in XLS(X) files
  • From: "andre.robin3" <andre.robin3 at>
  • Date: Thu, 13 Oct 2011 03:47:10 -0400 (EDT)
  • Delivered-to:
  • References: <j73gkt$fui$>

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> a écrit dans le message de 
news: j73gkt$fui$1 at
> 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

  • Prev by Date: Re: Taking the Arg of a complex number
  • Next by Date: Re: Plot function with two arguments
  • Previous by thread: Formatting in XLS(X) files
  • Next by thread: Re: Formatting in XLS(X) files