Word Doc Diff Excel Command Line Examples

Below are portions from a sample batch file, WDD_EXAMPLES.BAT, which is included in the installation directory. Examples below are used to compare Excel files.

You can include or exclude spaces between switches and parameters. For example, "/F1" is the same as "/F 1". For long file names you may be required to use double quotes. For example /S"C:\Program Files\MyApp\MyDoc.DOC".

Select an example that matches your needs closest and modify accordingly.

:=====================================================================

: WordDocDiff (WDD) Excel Example Batch File. (WWW.SoftInterface.COM)

: Find the example closest to your needs and modify accordingly.

: EXAMPLES 1 - 3, Excel File Comparison

: EXAMPLE 1 (Compare 2 Excel spreadsheets)

: EXAMPLE 2 (Compare 2 Excel spreadsheets, Specify sheet numbers)

: EXAMPLE 3 (Compare 2 Excel spreadsheets, Specify sheet numbers,

: rows and columns)

: EXAMPLES A - C, Report Creation

: EXAMPLE A (Compare 2 Excel spreadsheets, create Report (HTML, All In One)

: Exit when done

: EXAMPLE B (Compare 2 Excel spreadsheets, create Report (TXT)

: Exit when done

: EXAMPLE C (Compare 2 Excel spreadsheets, create Report (CSV)

: Exit when done

: NOTE: For long file paths use double quotes,

: i.e. /L"D:\Long Path\A.XLS"

:=====================================================================

:----------------------------------------------------------------------

: EXAMPLE 1 (Compare 2 Excel spreadsheets)

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log

:----------------------------------------------------------------------

: EXAMPLE 2 (Compare 2 Excel spreadsheets, Specify sheet numbers)

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

: Specify 2nd Sheet for both Master and Source files:

: /Y2 /Z2

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /Y2 /Z2

:----------------------------------------------------------------------

: EXAMPLE 3 (Compare 2 Excel spreadsheets, Specify sheet numbers, rows and columns)

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

: Specify 2nd Sheet for both Master and Source files:

: /Y2 /Z2

: Specify Rows 12-28 fo both Master and Source files:

: /1 12-24 /3 12-24

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /Y2 /Z2 /1 12-24 /3 12-24

:----------------------------------------------------------------------

: EXAMPLE A (Compare 2 Excel spreadsheets, create Report (HTML, All In One)

: Exit when done

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

: Create report to target file "D:\A\Report.HTM":

: /T D:\A\Report.HTM

: Specify HTML Report format:

: /R1

: Specify All In One style:

: /F1

: Open Report, exit when done:

: /O /X

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.HTM /R1 /F1 /O /X

:----------------------------------------------------------------------

: EXAMPLE B (Compare 2 Excel spreadsheets, create Report (TXT)

: Exit when done

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

: Create report to target file "D:\A\Report.TXT":

: /T D:\A\Report.TXT

: Specify TXT Report format:

: /R2

: Open Report, exit when done:

: /O /X

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.TXT /R2 /O /X

:----------------------------------------------------------------------

: EXAMPLE C (Compare 2 Excel spreadsheets, create Report (CSV)

: Exit when done

: Compare "D:\A\Descarte.XLS" to "D:\A\Plato.XLS":

: /M d:\a\Descarte.xls /S d:\a\Plato.xls

: Create Log file D:\A\Compare.LOG:

: /L D:\A\Compare.log

: Create report to target file "D:\A\Report.CSV":

: /T D:\A\Report.CSV

: Specify CSV Report format:

: /R3

: Open Report, exit when done:

: /O /X

:----------------------------------------------------------------------

WDD /M d:\a\Descarte.xls /S d:\a\Plato.xls /L D:\A\compare.log /T D:\A\Report.CSV /R3 /O /X