Technical Support

How to save comparison report in the external file on disk

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail support@SpreadsheetTools.com, or fill the Technical Request form on the Spreadsheet Tools website.

We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare here.

We've created a F.A.Q section on our website. It contains answers to the most common questions we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic

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:

Save Comparison Report in the external file

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:

Comparison Report saved in the HTML format

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.

See Also: