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
Save comparison report in the external file
xlCompare gives you ability to not only view differences between 2 workbooks, but you can also save the comparison report you've got in the file on disk.
File formats supported by xlCompare:
- HTML Document (.html)
- Text File (.txt)
We suggest you to use HTML format. HTML gives us more abilities to format the data. So this report is much better describes comparison results. Text file doesn't have abilities to format the data. Text report looks good only with fixed size font like Courier or Lucida Console. When usual fonts like Arial or Times New Roman you'll get a mess in the text. Also, we are going to continue improving HTML reports and make them as intuitive and flexible as possible.
Now let's see how to use this feature. In this topic we don't put our attention on how to get the comparison results. We think that you've opened 2 workbooks and get Difference Explorer window.
Image below highlights the command you should use:
Same command exists on both toolbars: in the main window and in the Difference Browser.
It invokes standard Save File dialog where you should select file name for your new report. You can select files of type: .html and .txt in the File Type combobox.
This is all you need xlCompare creates a report and opens it to you. If this is HTML report it is opened in your default browser. Typical report saved in the HTML format looks like this one:
File is virtually divided into 2 panels, each one displays changes relative to the corresponding document. Items are organized into the hierarchical structure, same as you see in the Difference Browser. Lines in the left and right panels are aligned to each other. You see corresponding values on the same places in both panes.