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