XML Converter Professional Edition
How to convert a Microsoft Excel spreadsheet into XML?
Recent versions of Excel claim "save as XML" features of one kind or another. Maybe that "claim" is too uneven. Excel does create well-formed XML documents, after all. However it is XML of a strikingly gruesome form, even for simple documents - nearly as shaggy and pitch-dark to the human eye as XSL-FO.
Whether you like or don't like Excel, or use it in your everyday working routine, you may be being forced to convert an Excel spreadsheet to XML at some point. And if you do not even have Excel in the first place, the quality of the Excel processor's "save as XML" output is questionable anyway. What do you do then?
Finally you got a decision you need software for processing XML.
XML Converter Professional Edition is the complete solution for the developer who wants the browse facilities provided in the
Standard Edition PLUS special modules, which provide command-line interface. Using the Professional Edition you will
be able to call XML Converter strictly from your own application, with no user interface, allowing you to convert Data Source to XML in batch mode.
What the special modules are included in Professional Edition?
XMLConverterCmd can accept quite a few command-line arguments. Many of these arguments can be omitted and XMLConverterCmd can use default
values instead of them. XMLConverterCmd expects command line arguments to be preceded by the "-" (dash) as normally used by DOS
programs. Also you can use a special configuration file default.cfg for defining and sending your parameters to XMLConverterCmd.exe.
If you define arguments in command-line then their values will have a high priority than the values have been defined in default.cfg.
There is a description of some XML Converter command-line arguments:
A Name of Data Source file with full path like:
A Name or a number of spreadsheet or table, which belongs to your Data Source file.
Default is empty string
If you decide to define the [SourceTableName/or Number] argument as a number
of table/spreadsheet you have to put this parameter after [SourceFileName] arguments.
Otherwise, if [SourceTableName/or Number] argument is name of table/spreadsheet
and contents spaces inside you must enclose it in "[ ]" brackets:
XMLConverterCmd.exe -rXLS -sC:\MyDir\MyBook.xls -n[First sheet 10] ...
Also you can leave this argument empty. It means XML Converter will generate one common xml
output file where data from all of your Data Source's spreadsheets/tables will be stored.
In this case you can create your own XML database. This software gives you ability to generate an output as a set of XML tables.
The Mapping method determines how each Source data column is mapped when a XML document is saved.
This argument should be omitted when TargetTypeName is not xml.
e - Map out as Element
a - Map out as Attribute
r - Map out as Row Content Default is e
Argument is replying to question: "Would you like to accompany your XML document
with a template XSL style-sheet?" This argument should be omitted when TargetTypeName is not xml.
no Default is no
If you are not a registered user of the XML Converter with command-line interface yet you can order the software online.
After that we will send to you your secure installation code and you will run your software with the parameter:
A special registration form will appear where you will be able to legalize your Converter.
If you want to get one XML file generated from all of MyBook.xls spreadsheets you
can use the signature:
XMLConverterCmd.exe -sC:\MyDir\MyBook.xls n
For this case final MyBook.xml file will be saved in directory C:\MyDir\ and will
content data from all spreadsheets. Also, this file will have special tags, such as
"workbook", "worksheet", "row", "field column=""", which allow you to directly access
and read the XML file by using DOM or SAX software.
The XMLConverterCmd.exe returns error codes:
0 - Ok
1 - Syntax error in command line
2 - Source file does not exist
3 - Source table does not exist
4 - Can't open source file
5 - Can't create XML file
6 - Error of XSL-template creating
7 - Can't create XSD file
8 - Error of DTD creating
9 - Can't connect to data
10 - Can't read data format
11 - Error of TrasX-Schema creating
12 - Error in "micro" - module
13 - Target file is not created
If you want to get one XML file generated from all of "MyBook.xls"
spreadsheets you can use the signature:
XMLConverterCmd.exe -sC:\\MyDir\\MyBook.xls n
For this case final "MyBook.xml" file will be saved in directory
"C:\MyDir\" and will content data from all spreadsheets. Also, this
file will have special tags, such as "workbook", "worksheet", "row", "field
column=""", which allow you to directly access and read the XML file by using
DOM or SAX software.
Also XMLConverterCmd supports ErrorLevel DOS variable. When using a dos batch file to execute XMLConverterCmd.exe, how do you go about error handling? There is the ErrorLevel variable being passed back to the batch file that can be interrogated to determine successful/unsuccessful completion of XML Converter Cmd. To try the functionality you should have a .bat file like the following:
echo Syntax error in command line
echo Source file does not exist
When XMLConverterCmd.exe interrupts its execution the special file XMLConverterCmd.err will be created where error reports are stored. This error message file contains both error numbers and their associated text messages. The error report is accompanied by the date and time when it occurred. Since the error message file created with XMLConverterCmd is a binary text file it can be accessed by any text editor.