[Date Index] [Thread Index] [Author Index]

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.
>
>