Copyright © 2007 Crane Softwrights Ltd.
$Date: 2008/07/15 23:23:37 $(UTC)
Table of Contents
This package from Crane Softwrights Ltd.'s free resource library [Crane Resources] contains the following components in support of extracting XML information from spreadsheets:
an Open Office macro [OOo] to convert a Microsoft .xls
file to an Open Document Spreadsheet .ods
file
an Ant script [Ant] to convert either a Microsoft .xls
file or an Open Document Spreadsheet .ods
file into a standalone XML file of the Open Document Format [ODF] XML vocabulary
an XSLT 2.0 stylesheet fragment [XSLT 2.0] to access table information found in an Open Document Format XML instance
The CraneXLS2ODSMacro-20061221-1600z.odt
Open Office template contains the installation instructions for a macro, and the macro itself, used to convert a standalone Microsoft .xls
file into a standalone Open Document Spreadsheet .ods
file.
The Crane-xls2ods2xml.xml
Ant script can be invoked from Ant using the <ant>
directive and nested <param>
parameters. The embedded documentation in the Ant script lists the parameters needed, with sample Ant invocation instructions.
The Crane-ods.xsl
XSLT 2.0 stylesheet fragment provides access to Open Document Format table constructs. The readme-Crane-ods.html
file details all of the entry points.
[Ant] Apache Ant http://ant.apache.org
[Crane Resources] Crane Softwrights Ltd. Free developer resources
[ODF] Open Document Format http://http://www.oasis-open.org/committees/office/
[OOo] Open Office http://www.openoffice.org
[XSLT 2.0] Michael Kay XSL Transformations (XSLT) Version 2.0 2007-01-23