Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2011

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

Search the Archive

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





  • 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