IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools
Command Line mode
Why command line mode is important?
It allows to use xlCompare as a part of the another process. You can intergrate this tool into the another application by using Command Line mode.
Ok. So, how to use xlCompare from the command line? Use this syntax:
xlCompare.exe < path to first workbook > < path to second workbook >
Compare only specific worksheets.
You can pass worksheet name to xlCompare by adding it to file name after | character. For example:
"C:\My Files\Sales Report.xlsm|Jan-16"
In this case Jan-16 worksheet is compared.
If worksheet name is not specified - xlCompare processed complere workbooks, including all worksheets and all VBA Modules.
Save comparison report.
To pass report file use following syntax: -r <path to report file>.
Save report as Table.
Add -tbl modificator to the command line string.