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


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

Re: Formatting in XLS(X) files

From Tyler <hayes.tyler@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Formatting in XLS(X) files
Date 2011-10-14 09:55 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j790va$i2t$1@smc.vnet.net> (permalink)
References <j73gkt$fui$1@smc.vnet.net>

Show all headers | View raw


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.

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