Show only differences + export those differences

[Tech4Ever]

Hi,

I would like to compare two excel files and I would like to show only the highlighted differences. Then, in a next step, I would like to export the output on the right side (the newer Excel file version; the other one is always from the past month). I´m using the Compare Excel Plugin.

Is there a way to achieve that?

[sdottaka]

If you set the Diff Context to 0 Lines as shown below, only the differences will be displayed.

In this state, focus on the right pane, press Ctrl+A and then Ctrl+C to copy only the differences to the clipboard. This can then be pasted into a text editor and saved.

You can also output the differences to a file by selecting the "Tools → Generate Report" or "Generate Patch" menu item.

[Tech4Ever]

Perfect, exactly what I was looking for! Thank you!!

[Andrej730]

Hi! I'm sorry if I'm missing something obvious but for me Ctrl-D seems to hide different lines instead of showing just them.

Left:

CompositorNodeCornerPin -> CORNERPIN
CompositorNodeCrop -> CROP
CompositorNodeCryptomatte -> CRYPTOMATTE
CompositorNodeCryptomatteV2 -> CRYPTOMATTE_V2
CompositorNodeCurveRGB -> CURVE_RGB
CompositorNodeCurveVec -> CURVE_VEC
Node <class 'bpy.types.CompositorNodeCustomGroup'> was skipped
CompositorNodeDBlur -> DBLUR
CompositorNodeDefocus -> DEFOCUS
CompositorNodeDenoise -> DENOISE
CompositorNodeDespeckle -> DESPECKLE
CompositorNodeDiffMatte -> DIFF_MATTE
CompositorNodeDilateErode -> DILATEERODE
CompositorNodeDisplace -> DISPLACE
CompositorNodeDistanceMatte -> DISTANCE_MATTE
CompositorNodeDoubleEdgeMask -> DOUBLEEDGEMASK
CompositorNodeEllipseMask -> ELLIPSEMASK
CompositorNodeExposure -> EXPOSURE
CompositorNodeFilter -> FILTER
CompositorNodeFlip -> FLIP
CompositorNodeGamma -> GAMMA

Right:

CompositorNodeCornerPin -> CORNERPIN
CompositorNodeCrop -> CROP
CompositorNodeCryptomatte -> CRYPTOMATTE
CompositorNodeCryptomatteV2 -> CRYPTOMATTE
CompositorNodeCurveRGB -> CURVE_RGB
CompositorNodeCurveVec -> CURVE_VEC
Node <class 'bpy.types.CompositorNodeCustomGroup'> was skipped
CompositorNodeDBlur -> DBLUR
CompositorNodeDefocus -> DEFOCUS
CompositorNodeDenoise -> DENOISE
CompositorNodeDespeckle -> DESPECKLE
CompositorNodeDiffMatte -> DIFF_MATTE
CompositorNodeDilateErode -> DILATE_ERODE
CompositorNodeDisplace -> DISPLACE
CompositorNodeDistanceMatte -> DIST_MATTE
CompositorNodeDoubleEdgeMask -> DOUBLE_EDGE_MASK
CompositorNodeEllipseMask -> ELLIPSEMASK
CompositorNodeExposure -> EXPOSURE
CompositorNodeFilter -> FILTER
CompositorNodeFlip -> FLIP
CompositorNodeGamma -> GAMMA

WinMergeU_ed5GKYEQRq.mp4

[sdottaka]

If the View → Diff Context → Invert (Hide Different Lines) menu item is checked, uncheck it.

[Andrej730]

Thank you!