vijaydinni's avatar
vijaydinni
New Member
8 years ago
Status:
New Idea

Add feature to compare Spreasheets and output like Table Checkpoints

Hi

 

In our automation we use a lot of excel reports that are output however i do not see a way of comparing and outputting exactly what row and values have changed to prior release. I am currently using the extension script (https://support.smartbear.com/viewarticle/42199/) which just gives information on whether there are any mismatches and the count which is of not much use since we are going to do the manual work of opening and trying to find where the mismatches are. Since spreadsheets are used heavily i suggest to come up with some checkpoint that outputs something like Table checkpoint with each sheet name, row, text/value displayed  OR enhance the script extension to do the same. 

 

Best regards

Vijaykumar

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    8 years ago

    Have you considered writing a compare routine using the COM object Excel.Application to do the comparison the way you need to?

    One of the beauties about Script Extensions is that they are easily modified. 

     

    1) Rename the extension from filename.tcx to filename.zip

    2) Extract the contents of the zip to a folder

    3) modify the script file and description.xml file with any changes needed

    4) update the ZIP file with the new files

    5) Rename from filename.zip to filename.tcx

     

    I will be conducting a webinar in a few weeks with SmartBear on using Script Extensions and how to build them if you're interested.

    • mkharsha's avatar
      mkharsha
      Occasional Contributor
      12 months ago

      How I can get the script extension? Link is not wokring