Empower yourself with File compare tools from Softinterface.

WDD Excel Command Line Examples

 

WordDocDiff Home

Excel Examples

Document 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