Version: 0.1

Usage: xmlexcel [flags] file1 [file2 . . . ]
-----

    This program scans any ASCII file containing XML elements and converts the
    contents into a TXT file suitable for importing to a spreadsheet program
    such as Excel. The user specifies an optional element name by which
    individual records are denoted within the XML.

    Subelements within each record are converted into individual columns 
    in the resulting spreadsheet with one record per line. When a subelement
    occurs multiple times within a single record, all the values of the
    subelement are merged into a single column.

    For example:

        <holiday>
            <name>Christmas</name>
            <color>red</color>
            <color>green</color>
            <month>December</month>
        </holiday>
        <holiday>
            <name>Independence Day</name>
            <color>red</color>
            <color>white</color>
            <color>blue</color>
            <month>July</month>
        </holiday>
        ...

    Converts as:

        -------------------------------------------------+
        | name             |  color           | month    |
        -------------------------------------------------+
        | Christmas        |  red green   `   | December |
        | Independence Day |  red white blue  | July     |
        ...

Flags:
-----

-?              Print help information.

-help           Print help information.

-element name   Specify the name of the XML element which spans 
                each record. For example, if the XML file 
                presents each record as follows:

                    <item>
                        <author>John Q. Public</author>
                        <title>My Life</title>
                        <date>2004</date>
                    </item>
                    <item>
                        <author>Fred Fisher</author>
                        <title>Life in the Sun</title>
                        <date>1924</date>
                    </item>

                Then specify:

                    -element item

                If no element is specified, then a the record
                separator is assumed to be "record" as if you
                had specified:

                    -element record

Running in Windows:
------------------

    The program is available as an XMLEXCEL.EXE and may be run in Windows as
    follows:

    1. Unzip the downloaded distribution into a folder. We'll call this
       FOLDER1.
    2. Open explorer in FOLDER1.
    3. Open another copy of explorer where your XML file is that you
       want to convert. We'll call this FOLDER2.
    4. Drag the XML file from FOLDER2 and drop it over the
       XMLEXCEL.EXE file in FOLDER1.
    5. The XML file will be converted and a file by the same name, but
       with a TXT extension will appear in FOLDER2.
    6. Open the newly-created file with your speadsheet program (e.g., Excel).

Written by Tony Garland, contact@SpiritAndTruth.org



0.1     Initial version produced for use by Todd Bolen of
        www.BiblePlaces.com.