| Parameter |
Description |
|
|
| File1 |
name of the first file |
| File2 |
name of the second file |
| /s:SheetName |
sheet name of workbook |
| /allsheets |
compares all the sheets that have the same names in two workbooks |
| @UL:LR!ID |
parameters of the range and ID columns, UL - upper-left corner of the range, LR - lower-right corner of the range, ID - columns with unique identifiers. Examples: @A1:D12!A @A1:D12 @:D12 @!A,B |
| /r:ReportName |
saves the XLS Differences report |
| /close |
closes Excel Compare (for example with the key /r:) |
| /closef, /closef+ |
closes all the files opened by MS Excel after comparing |
| /closef- |
bans closing the files opened by Excel (default) |
| /closer, /closer+ |
closes all reports' workbooks after comparing |
| /closer- |
bans closing reports (default) |
| /project:ProjectName |
the project's file name with the extension .ecp |
| /page:PageName |
page name in the project |
| /allpage |
compares files from all pages of the project |
| /rs:ReportSheetName |
name of a new report sheet |
| /rcm:Method |
the Report Creation Method option.Possible values: v, vf, dw. Default value: dw. |
| /mcm:Method |
the Main Comparison Method option.Possible values: b, l, id. Default value: l. |
| /cr:Method |
the Comparison Method for two rows. Values: 0, 1, 2, 3. Default value: 0. |
| /sr:Percent |
the 'Similarity Rate' value. Minimum value is 10 and the maximum is 99. Default value: 65% |
| /nc |
if no difference has been detected, the report will not be created |
| /ow |
creates all the reports of the project in the same workbook |
| /ih- |
allows to avoid inserting links into the report |
| /hc+ |
highlight the cells that have changed (default) |
| /hc- |
bans highlighting the cells that have changed |
| /dr+ |
divides the report into three sheets: deleted, added and changed data |
| /dr- |
bans dividing the report into three sheets (default) |
| /rcs+ |
replicates compared sheets in a new report workbook |
| /rcs- |
bans replicating compared sheets in a new report workbook (by default) |
| /cui, /cui+ |
allows to compare rows, which have ununique identifiers when the 'Unique identification' method is used |
| /cui- |
bans comparing rows, which have ununique identifiers (by default) |
| /macros:FileName |
attaches user-defined macros to the report worksheet (sheet level) from the external 'FileName' file (*.bas) |
| /proc:Procedure |
runs the 'Procedure' macro after comparing |
| /gmacros:FileName |
attaches user-defined macros to the report workbook (global macros) from the external 'FileName' file (*.bas) |
| /gproc:Procedure |
runs the 'Procedure' macro after the report is created |
| /classes:FileName |
adds user-defined classes from the external 'FileName' file (*.cls) |
| /code:FileName |
adds the code from the external 'FileName' file to a module |
| /module:ModuleName |
module name |
