Is it possible to compare excel sheet in PTC integrity 10.6 ?

[spatel-9]

Excel sheet  is checked-in  in the server  and changed locally. SO is it possible to compare it ?

[KaelLizak]

Hello Sanket Patel‌,

If it's a binary file, it's not possible out-of-the-box.  If it's a text file, it is possible.

Typically, Excel files are binary files.  .xslx files, for instance, are a zipped directory structure containing xml files.  Even though xml files could be compared (one by one), the zipped structure of the container file means it's a binary, and so can't be meaningfully compared by Integrity Lifecycle Manager.

Regards,
Kael

[tdalon]

As Kael said: Integrity does not support it out-of-the-box with its native Diff Viewer tool.

You could use a customized Diff Tool that open a different tool for XLS file.

We do this for example for Simulink .mdl files: we use a specific tool, for other ASCII files we use BeyondCompare.

[mrump]

Beyond Compare in Version 2 or higher also supports the comparison of Office File Formats like WORD or EXCEL.

There are rules-set you can Import, that convert the e.g. Excel sheet into a temp text representation that can be compared with the Standard Beyond Compare UI.

It's not perfect but it gives at least a hint about the differences.

[spatel-9]

@mrump‌ Is it possible to provide those rule  set procedure? I am new to customization of View set.

[tdalon · Accepted solution]

In this case to configure the Diff Tool in Integrity to BeyondCompare follow:

To use an external diff software like beyond compare, you can set this in the MKS client in File -> Edit Preferences -> Configuration Management -> Diff and Merge tools. In the Custom Command field you can configure your own diff application. In the case of Beyond Compare 3.x the command is

  "<your path to BC3>\bcomp.exe" /fv="Text Compare" /title1="{1}" /title2="{2}" "{3}" "{4}" 

You can also use BC as Merge Tool. The command is:

  "D:\PortableApps\BeyondCompare3Portable\BCompare.exe" /title1="{1}" /title2="{2}" "{5}" "{6}" /savetarget="{7}"

Then look how to compare Excel files in BeyondCompare for example Beyond Compare Technical Support.

[schinnaswamy-2]

can any one help What is the preference command for Beyond comapre 4 (Version 4.0.7 (build 19761)) in PTC integrity 10.5 (10.5.0.5479) ?

[sreeckg]

just check this url, hope it is helpful for you.

https://www.scootersoftware.com/support.php?zz=kb_vcs#mksintegrity