Crane's Spreadsheet to XML conversion/extraction environment

G. Ken Holman

Crane Softwrights Ltd.

$Date: 2008/07/15 23:23:37 $(UTC)


Table of Contents

1. Introduction
2. Converting an XLS file to an ODS file
3. Extracting the XML file from an ODS file
4. Accessing the XML file using XSLT 2
Bibliography

1. Introduction

This package from Crane Softwrights Ltd.'s free resource library [Crane Resources] contains the following components in support of extracting XML information from spreadsheets:

2. Converting an XLS file to an ODS file

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.

3. Extracting the XML file from an 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.

4. Accessing the XML file using XSLT 2

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.

Bibliography

[Ant] Apache Ant http://ant.apache.org

[Crane Resources] Crane Softwrights Ltd. Free developer resources

[OOo] Open Office http://www.openoffice.org

[XSLT 2.0] Michael Kay XSL Transformations (XSLT) Version 2.0 2007-01-23