Drexel dragonThe Math ForumDonate to the Math Forum



Search All of the Math Forum:

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


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

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

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/
want.
TEMPLATE_some_report.xls

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

templatedir/TEMPLATE_some_report.xls -> report/
some_report_file_yyyymmdd.xls

[3] Control the writing of your output to the appropriate cells in
"reportdir/some_report_yyyy_mm_dd.xls"

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.

Cheers,

t.





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

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.