MathGroup Archive 2011

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

Search the Archive

Re: Formatting in XLS(X) files

  • To: mathgroup at
  • Subject: [mg122123] Re: Formatting in XLS(X) files
  • From: "Alexey Popkov" <lehin.p at>
  • Date: Sat, 15 Oct 2011 06:03:54 -0400 (EDT)
  • Delivered-to:
  • References: <j73gkt$fui$> <j790va$i2t$>
  • Reply-to: "Alexey Popkov" <lehin.p at>

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.


----- Original Message ----- 
From: "Tyler" <hayes.tyler at>
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.

  • Prev by Date: Problems plotting 3D surface and using manipulate
  • Next by Date: Re: Export
  • Previous by thread: Re: Formatting in XLS(X) files
  • Next by thread: Re: Formatting in XLS(X) files