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


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

Re: Formatting in XLS(X) files

From "Alexey Popkov" <lehin.p@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Re: Formatting in XLS(X) files
Date 2011-10-15 10:07 +0000
Organization Steven M. Christensen and Associates, Inc and MathTensor, Inc.
Message-ID <j7bm13$35f$1@smc.vnet.net> (permalink)
References <j73gkt$fui$1@smc.vnet.net> <j790va$i2t$1@smc.vnet.net>

Show all headers | View raw


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@gmail.com>
Newsgroups: comp.soft-sys.math.mathematica
Sent: Friday, October 14, 2011 1:55 PM
Subject: 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.
>
> 

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