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