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

Forum|Forum|10 years ago
May 9, 2016
3 replies
5450 views

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

Best answer by tdalon

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.

K

KaelLizak

16-Pearl

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

T

tdalon

1-Visitor

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.

M

mrump

16-Pearl

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.