I do it when testing: We have a really huge set of "reference files" that our test suite must create in order to verify FlexCel is working correctly. I do it when reverse engineering a feature: If I want to find some undocumented byte that changes some feature, I save the file in Excel with and without the feature, open both files and find what changed. Previous" or "diff" with any other revision.If there is one thing I do a lot is playing "find the differences" with xls and xlsx files.
In PlasticSCM client items view, mark your excel sheet, do a "diff with.Place the Beyond Compare for *.xlsx files to be the first in the list.Insert the full path to BCompare.exe with the needed arguments: "C:\Program Files\Beyond Compare\BCompare.exe" Choose "Use this tool for files with extension:".In the Define Diff tool configuration window choose:.In PlasticSCM client go to->Preferences->Diff tools-ADD.
To setup Plastic SCM with Beyond Compare diff tool: The procedure described here to setup Plastic SCM with an external diff tool can be applied virtually to any other tool.įind your favorite compare/diff tool and install it in my case I installed Beyond Compare to diff 2 excel files within Plastic Gui.īeyond Compare executable is called BCompare.exe and can be executed from the command line with c:\BCompare.exe file1excel.xlsx file2excel.xlsx, so basically when you setup Plastic SCM with Beyond Compare and diffing from Plastic SCM on a revision of a versioned excel file, Plastic will call the BCompare.exe and feed it with the two filenames (or revisions) needed to perform the diff. The tool we will use here is Beyond Compare from Scooter Software.Īlthough Plastic SCM comes with a powerful diff tool, but there can be times were you want to use your preferred tool to diff some binary files of any type of your choice with your diff tool, an example here could be Microsoft excel files, which are not supported by our diff tool but Beyond Compare which is a dedicated file compare tool can handle. In this blogpost we will go through very few steps to setup an external diff tool to work with Plastic SCM.
0 kommentar(er)
