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: [mg122433] Re: Formatting in XLS(X) files
  • From: Josselin Noirel <commercialat at jnoireldot.fr>
  • Date: Fri, 28 Oct 2011 05:36:16 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <j73gkt$fui$1@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




  • Prev by Date: Matematica Beginner/Student and Mysql
  • Next by Date: Re: Integral points on elliptic curves
  • Previous by thread: Re: Formatting in XLS(X) files
  • Next by thread: Re: Formatting in XLS(X) files