Re: Formatting in XLS(X) files
- To: mathgroup at smc.vnet.net
- Subject: [mg122123] Re: Formatting in XLS(X) files
- From: "Alexey Popkov" <lehin.p at gmail.com>
- Date: Sat, 15 Oct 2011 06:03:54 -0400 (EDT)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- References: <j73gkt$fui$1@smc.vnet.net> <j790va$i2t$1@smc.vnet.net>
- Reply-to: "Alexey Popkov" <lehin.p at gmail.com>
I used another way: 1) Export data from Mathematica to a text file in CVS format 2) Create a template Excel file which will auto-import this file as external data source. Such file may be created in Excel 2003 via the menu command Data-> Import external data-> Import data... You can tune it to automatically import data every time the file is opened or by demand. HTH, Alexey ----- Original Message ----- From: "Tyler" <hayes.tyler at gmail.com> Newsgroups: comp.soft-sys.math.mathematica Sent: Friday, October 14, 2011 1:55 PM Subject: [mg122123] Re: Formatting in XLS(X) files > 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. > >