The article directories

  • A, Spreadsheet to Compare
    • 1. Method of use
    • 2. Contrast terms
    • 3. Differential output
  • Use TortoiseSVN Spreadsheet Compare to TortoiseSVN
    • Write a batch
    • 2. Set the comparison tool on the SVN
      • 1. Select Settings
      • 2. Modify diff to view the call

A, Spreadsheet to Compare

  • Spreadsheet Compare is a Spreadsheet comparison tool that allows you to Compare the differences between two files.

1. Method of use

1. Start menu;

2, Enter Spreadsheet Compare;

3. Select two files for comparison;

2. Contrast terms

  • The bottom panel, the most left can check the items to be compared, including the value of the grid, formula, grid format, the entire table structure and so on;

3. Differential output

  • The lower panel, in the middle is the actual difference output report;

  • For the two Excel tables, the difference output is as follows:

1) Sheet; 2) Add rows; 3) Formula changes; 4) Value change; 5) The change of the corresponding value of the formula; 6) The color change of the grid;

Use TortoiseSVN Spreadsheet Compare to TortoiseSVN

Write a batch

  • The purpose of batch is to call Spreadsheet Compare from the command line, and the two comparison files are passed in as arguments and written to a temporary file.
@echo off
chcp 65001
set toolpath=%~dp0
echo% ~ 1 >"D:\\temp.txt"
echo% ~ 2 > >"D:\\temp.txt"
"C:\Program Files\Microsoft Office\root\vfs\ProgramFilesX86\Microsoft Office\Office16\DCF\SPREADSHEETCOMPARE.EXE" "D:\\temp.txt"
Copy the code
  • Batch processing can be placed directly on drive D and named excelcompare.bat.

2. Set the comparison tool on the SVN

1. Select Settings

2. Modify diff to view the call

1) Select the Diff Viewer; 2) Choose Advanced… ; 3) add.xlsx; 4) Add the batch path and parameters (note the double quotation marks);

	"D:\ExcelCompare.bat" %base %mine
Copy the code