Command line usage XLS to JSON Converter
This topic describes how to use XLS to JSON Converter command line parameters
You can use them to specify actions, which must be performed by the program at launch.
Command line parameters allows you to launch XLS to JSON Converter from your own applications, command files, and so on.
Using command line can save you a lot of time, you can automatize everyday tasks and run them with a single click or by scheduler.
The basic syntax is:
xls2json.exe c:\tmp\source.xls -output=c:\tmp\ -batch [other parameters]
xls2json.exe c:\tmp\source.xlsx -output=c:\tmp\ -silent [other parameters]
Source file, Output file or folder, and -batch or -silent parameters are mandatory.
runs the app and displays a main window
runs the app and does not display any windows.
We recommend to use -batch during tuning and testing and then replace it to -silent
The long command line does not look pretty.
Therefore the good solution is to put command line parameters to another file - one parameter per line and run converter as:
You can combine parameters in the file and in the command line.
You can use comments, just add ; in the beginning of a line
xls2json.exe c:\tmp\source.xlsx @c:\tmp\params.ini
;overwrite existing files
It is hard to remember all parameters, so we created a really great helper for you: Expert mode!
Just launch XLS to JSON Converter, select source file(s), the output file/folder,
select necessary parameters, such as a field delimiter, code page, quotes etc.
Then click the button "Expert mode" and you will see how all your settings become command line parameters!
Moreover, this dialog allows you to save them as command .bat file, and a shortcut, and as .ini
If you did everything correct, you can run the converter by clicking on .bat or shortcut.