Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #5630
| 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> |
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
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