The Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Math Forum » Discussions » Inactive » comp.soft-sys.math.mathematica

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Formatting in XLS(X) files
Replies: 8   Last Post: Oct 29, 2011 6:41 AM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]

Posts: 79
Registered: 7/20/08
Re: Formatting in XLS(X) files
Posted: Oct 14, 2011 5:03 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

Another option, if this is going to be a regular report generated I've
used in the past is:

[1] Create a blank template XLS file with the formatting you require/

[2] In your code, make a copy of the file

templatedir/TEMPLATE_some_report.xls -> report/

[3] Control the writing of your output to the appropriate cells in

I find this has the advantage of not having to worry about picking up
VBA and the template can be altered fairly easily without messing with
the main code. However, this does become problematic if the report is
constantly changing and somewhat painful.

Sorry I couldn't help with the actual question, but hopefully it might
offer a quick workaround for you in the meantime.



Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.