Empower yourself with document comparison tools from Softinterface.

'Diff Doc' - Command Line Excel Comparison Examples

(Command Line or GUI Driven file comparison)

 

Command Line

Document Examples

Excel Examples

Folder Examples

The 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.

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

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

: 'Diff Doc' 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

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

 

DiffDoc /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

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

 

DiffDoc /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

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

 

DiffDoc /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

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

 

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

 

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

:    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

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

 

DiffDoc /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

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

 

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

 

Copyright © 1999-2008 by SoftInterface, Inc. All rights reserved.