Convert Excel to XML from the Command Prompt
Once you have created your Convert Excel to XML scenario in XMLBlueprint you can run it from the Command Prompt, depending on your Windows' version.
Windows 11
|
1. | Open a Command Prompt:Win+X > Command Prompt |
2. | Change the directory to "Scripts":cd C:\Program Files\XMLBlueprint 22\Scripts |
3. | Run the ConvertExcelToXML batch:ConvertExcelToXML {Scenario} {Excel File} {Output File}Scenario -- Name of the Convert Excel to XML scenario that was created earlierExcel File -- Path or URL of the Excel fileOutput File -- Path or URL of the Output file that will be generated |
Windows 10
|
1. | Open a Command Prompt:Win+X > Command Prompt |
2. | Change the directory to "Scripts":cd C:\Program Files\XMLBlueprint 22\Scripts |
3. | Run the ConvertExcelToXML batch:ConvertExcelToXML {Scenario} {Excel File} {Output File}Scenario -- Name of the Convert Excel to XML scenario that was created earlierExcel File -- Path or URL of the Excel fileOutput File -- Path or URL of the Output file that will be generated |
Converting CSV to XML automatically on a regular basis
To run conversions on a regular basis, you can use Windows' Task Scheduler.
See Also