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:
ChristmasredgreenDecemberIndependence DayredwhiteblueJuly
...
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:
John Q. PublicMy Life2004Fred FisherLife in the Sun1924
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.