Command Line Examples - Excel

Below are some examples to choose from. Select the one closest to what you require and modify it. If you are have any trouble using these examples, please see:

Using the Command Line Interface

Helpful Hints for Creating a Command Line

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.

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:

Using the Command Line Interface

Helpful Hints for Creating a Command Line

Command Line Examples - General File Comparison

Command Line Examples - Folder Comparison