Command Line Parameters
ExcelPipe can be run from a DOS shell or from a shortcut with parameters to make it run automatically. This is very useful for automation and scheduling (by making the short cut an entry in the Start Up folder), and for running ExcelPipe from a batch file. Here is a complete example:
"C:\Program files\ExcelPipe\excelpipe.exe" "/f=my replaces.epp" myfile1.xls myfile2.xlsx /G /Q
Note
- Any commands with embedded spaces must be surrounded with double quotes. You must surround the entire command/setting combination e.g. "/f=c:\Program Files\ExcelPipe\my replacements.epp" NOT /f="c:\Program Files\ExcelPipe\my replacements.epp"
- Windows limits the command line length to about 260 characters. You can
overcome this limitation by using the /Z=
> command to load command line parameters stored in a file. Note that you MUST remove any double quotes from around commands with embedded spaces when you put them in the command file.
Conventions used below:
<">> surrounds text that is to be entered. Do NOT enter the '<' and '">>' characters
Alternatives are shown in square brackets '[' and ']' with a pipe '|' character between them. Do NOT enter the square brackets or the pipe character - just type the single alternative you require.
Usage:
"C:\Program files\ExcelPipe\excelpipe.exe" [/MINIMIZED|/MAXIMIZED] ["/F=my replaces.epp"] [commands] [filenames] [/G [/Q]]
Where [commands] is zero or more of:
[filenames] | Any files, folders or filename specifications (e.g. *.doc) specified on the command line will cause ExcelPipe to select the 'Process List of Files' option and add the given data. If your settings already specifies a list of files, those from the command line are appended. |
/F=<.epp filename">> | Opens a ExcelPipe settings file. |
/REPORT= |
At the conclusion of the job, a text file report is written to the given filename. The /REPORT parameter must be after any /F command and before the /G command. |
/G | Go. Begin processing replacements with ExcelPipe. Processing of the command
line does not continue until the processing job is complete. Not available in the Evaluation Edition. |
/GS | Same as /G, but search only mode. Not available in the Evaluation Edition. |
/I= |
Imports a search/replace list from Excel, Tab or CSV-delimited file, and adds it to the end of the grid. The current options settings are used for each row added. |
/MAXIMIZED | Opens the application maximized. |
/MINIMIZED | Opens the application minimized. |
/Q | Quit ExcelPipe at the end of processing. |
/Z= |
Read command line parameters from the specified file. Very
useful for performing large numbers of changes, or for working around the Windows
limitation of approx 260 characters on the command line.
For example, if you had the long command line
This would change to something like
and the file commands.txt would contain
|