Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #5630

Re: Formatting in XLS(X) files

From "andre.robin3" <andre.robin3@wanadoo.fr>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Formatting in XLS(X) files
Date 2011-10-13 07:48 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j76548$29u$1@smc.vnet.net> (permalink)
References <j73gkt$fui$1@smc.vnet.net>

Show all headers | View raw


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


Back to comp.soft-sys.math.mathematica | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Formatting in XLS(X) files Josselin Noirel <commercialat@jnoireldot.fr> - 2011-10-12 07:46 +0000
  Re: Formatting in XLS(X) files "andre.robin3" <andre.robin3@wanadoo.fr> - 2011-10-13 07:48 +0000
  Re: Formatting in XLS(X) files Tyler <hayes.tyler@gmail.com> - 2011-10-14 09:55 +0000
    Re: Formatting in XLS(X) files "Alexey Popkov" <lehin.p@gmail.com> - 2011-10-15 10:07 +0000
  Re: Formatting in XLS(X) files "Chris Degnen" <degnen@cwgsy.net> - 2011-10-16 20:45 +0000
  Re: Formatting in XLS(X) files Josselin Noirel <commercialat@jnoireldot.fr> - 2011-10-28 09:43 +0000
    Re: Formatting in XLS(X) files "andre.robin3" <andre.robin3@wanadoo.fr> - 2011-10-29 11:18 +0000

csiph-web