Examples of Excel Comparison by Command Line
Have a question? Ask us! We love to help!
Below are some examples to choose from. Select the example closest to what you require and modify it. If you have any trouble using these examples see:
Note: If you don't specify a particular option in the command line, the option will default to whatever was last set in the user interface.
Examples 1-3 will open DiffDoc once the compare is complete. Examples 4-6 close DiffDoc, but do create a report which is opened in the default app (e.g. Browser, Notepad, Excel).| Example | Details |
|---|---|
Compare two Excel worksheets |
|
Compare two Excel worksheets; specify sheet numbers |
|
Compare two Excel worksheets; specify sheet numbers, rows and columns |
|
Compare two Excel worksheets; create HTML report |
|
Compare two Excel worksheets; create TEXT report |
|
Compare two Excel worksheets; create CSV report |
Example 1
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log
This command line instructs DiffDoc to:
- Compare two Excel worksheets.
- Generate a log file.
Because we don't specify which sheets or rows/columns to compare, the complete contents of the first sheet in each workbook will be compared.
Example 2
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /V /Y2 /Z2
This command line instructs DiffDoc to compare two workbooks, but only compare the second sheet.
/Y2 and /Z2 command 'Diff Doc' to compare the second sheet of the original file to the second sheet of the modified file.
The /V switch commands 'Diff Doc' to display a pop up message to report on the comparison. This is handy for debugging purposes.
Note: You can modify the /Y and /Z switches to compare second and third sheets with /Y2-3 and /Z2-3 (or /Y2, 3 and /Z2, 3) .
Example 3
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /Y2 /Z2 /1 12-24 /3 12-24
This command line instructs DiffDoc to compare two workbooks, specifying, not only which sheets, but also which rows to include in the comparison.
In this example, we specify rows 12-24 for both the Original and Modified Excel files with the /1 and /3 switches respectively. A log file is created with the /L switch to store the status of the comparison.
The /2 and /4 switches can be added to specify which columns to include in the comparison, as the /1 and /3 switches were used above.
Example 4
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.HTM /R1 /F1 /O /X
This command line instructs DiffDoc to compare two Excel spreadsheets and create a HTML (/R1) All In One style (/F1) report which opens (/O) and then closes 'Diff Doc' (/X).
A log file (/L) is also created.
Example 5
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.TXT /R2 /O /X
This command line instructs DiffDoc to compare two Excel spreadsheets and create a TXT (/R2) report which opens (/O) and then closes 'Diff Doc' (/X).
A log file (/L) is also created.
Example 6
DiffDoc /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.CSV /R3 /O /X
This command line instructs DiffDoc to compare two Excel spreadsheets and create a CSV (/R3) report which opens (/O) and then closes 'Diff Doc' (/X).
A log file (/L) is also created.
See Also:
