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" /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=<filename> 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] [/G [/Q]]
Where [commands] is zero or more of:
| /F=<.epp filename> |
Opens a ExcelPipe settings file. |
| /G |
Go. Begin processing replacements with Excel. Processing of the command line does not continue until the processing job is complete. |
| /I=<filename> |
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=<filename> |
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
start /w excelpipe.exe "/f=my special filter.epp" /g "/f=my special filter2.epp" /g "/f=my special filter3.epp" /g "/f=my special filter4.epp" /g /q
This would change to something like
start /w excelpipe.exe /z=commands.txt
and the file commands.txt would contain
/f=my special filter.epp
/g
/f=my special filter2.epp
/g
/f=my special filter3.epp
/g
/f=my special filter4.epp
/g
/q
|
|
