Using
Exult from the command line
The AdeptXLS XML to XLS Converter includes a command-line program which can be used for batch conversions. While the Wizard interface is very useful for interactive conversion, the command line can be used for automated scheduled conversions.
The command line program is called AdeptxlsCmd.exe and
should be installed in the same directory as
AdeptXLS.exe. The examples below describe several usage
scenarios.
Click here for the complete usage syntax.
The following examples all assume that AdeptxlsCmd.exe is present in the PATH. If not, please substitute the location of the program (by default, C:\Program Files\Novixys Software\Adept <Ver>\AdeptxlsCmd.exe, but maybe different on your computer depending on where you chose to install it).
- Merge multiple XML files and extract the data to Microsoft Excel:
- Merge all the XML files in a directory into a database and extract
as an Excel spreadsheet. The location of the output Excel spreadsheet
is specified as the first argument. In this example, any existing
output files will not be overwritten.
AdeptxlsCmd.exe Example1.xls C:\XMLFiles\*.xml
- Convert XML files matching the pattern a*.xml to an XLS file:
- This example illustrates the use of a more specific wildcard to
select the XML files for merging and exporting to XLS.
AdeptxlsCmd.exe Example2.xls C:\XMLFiles\a*.xml
- Convert files in multiple locations at once:
- This example shows how to convert multiple XML files in different
directories with the output written to a single Excel spreadsheet.
AdeptxlsCmd.exe Example3.xls C:\First\Path\To\XML\*.xml C:\Second\Path\To\XML\*.xml
- Overwrite existing output files
- To overwrite existing files, use the -w option as
shown here.
AdeptxlsCmd.exe -w Example4.xls C:\Data\*.xml
Click here for the complete usage syntax.
 a Free Trial |
 for US$100 |
 More Info |