Problems? Is your data what you think it is? | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Sounds like you've already got a workable answer, but for the record, I've had a lot of luck constructing feature-rich Excel files using Excel and some sample data, and then saving them as XML. Once you've got an Excel/XML file, it's not difficult to open in up and extrapolate the format and location of the data part of the file. Now you have a 'template' Excel document, and it's just a matter of substituting your data for the sample stuff, using whatever means you feel comfortable with. (Perl, PHP, XSLT, etc) It's worth pointing out that although Excel names XML files '.xml', you can name them the usual '.xls' and Excel will open them just the same. I make it sound straightforward, and it is, but do expect to spend some time ironing out bugs related to what formats and tags Excel expects. Xaositect - Whitepages.com In reply to Re: Creating Pivot tables from Perl
by Xaositect
|
|