Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2011
    Posts
    3

    Default Ability to export results to Excel

    Hi,

    Having completed a compare of two files I'd like to be able to export the results in csv or xls format. Ideally I'd like to export just the diffs:
    - Values in file A
    - Values in file B
    - It would be ideal to see the differences as well

    Is anyone able to advise me if this is possible?

    Thanks,
    Richard

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,949

    Default

    Hello,

    If you have compared CSV files and made edits to one side or the other, you can perform a Save As to save that CSV file. We do not support saving or editing XLS files.

    Our report formats only support output into plain text, HTML, or the Printer.

    If you are in the Data Compare, you can use the Display Filters to show Only Differences, then perform a Select All, copy, and paste into Excel.

    Alternatively, you can also open your files in the Text Compare and perform similar steps. To open Excel in the Text Compare, you will need an additional file format:
    http://www.scootersoftware.com/downl...oreformats_alt

    Let us know if you have any questions.
    Aaron P Scooter Software

  3. #3
    Join Date
    Feb 2011
    Posts
    3

    Default

    Aaron,

    Thanks for the reply.

    When I'm in a Data Compare and perform Select All, Copy and Paste it only copies data from one of the files and you loose all formatting / highlighting of differences.

    If I want to have a record of what has changed I have to:
    1. Filter o differences only
    2.Copy the differences of file one from Data Compare as you have suggested.
    3.Copy the dfferences from file second file.
    4. Manually do a diff in Excel to show what the differences are there.

    Is there a way to record / report the differences in a cleaner / more automated fashion? I need to be able to report all of my differeces as test evidence of pre and post file versions.

    Thanks,
    Richard

  4. #4
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,759

    Default

    Hi Richard,

    Have you tried using the "Session > Data Compare Report" command? If select "HTML report" as the output type, it will export with colored differences. If you want the report as XLS, open the HTML file in Microsoft Excel, then do a Save As of type XLS.
    Chris K Scooter Software

  5. #5
    Join Date
    Feb 2011
    Posts
    3

    Default

    Chris,

    I wasn't aware of the Data Compare Report functionality. Exporting HTML reports (and being able to open those in Excel) meets my needs of exporting results from compares.

    Many thanks,
    Richard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •