| Module Info
| Add a review of Spreadsheet-WriteExcel-FromXML
This module was just what I needed to make complex spreadsheets
reports out of my various xml sources.
Just had to write some XSLT to put everything in one XML document
of the FromXML type, three lines of perl (including comment and use
lines :-) and voilï¿½. Just brilliant.
One thing that is not immediately clear from the doc is how central
is the FromXML.dtd file. Furthermore, it is not installed anywhere
from the default make install, so one may well overlook how cool
the whole thing is :-)
Finally, a bit of advice for Windows users: in case some cells
of the Excel file are hard to import into Access, just open it
with Open Office (or Excel, mind you) and save it before importing it.
This library is pretty broken at present, but I have high hopes for it, since Spreadsheet::WriteExcel is pretty kick-ass.
This is a very clever idea.
The module uses a DTD to define a simple XML format that can be converted to an Excel file using Spreadsheet::WriteExcel as a backend.
This is a potentially powerful approach since it effectively decouples your data from Perl, apart from a single filter program, and allows you to create Excel files using your preferred XML tools.
Requires Spreadsheet::WriteExcel version 0.42.