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.