Svn diff for binary (excel file)

Question

I set up the svn repository for excel file,

So, I checked and created myworking directory. Then I changed the excel file and I wanted to see the svn diff changes

which says the file is marked with a binary event, although I changed

Subversion client configuration file and

[miscellany] enable-auto-props = yes 

and also I added this line

 *.xlsx = svn:mime-type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 

When i use

 svn proplist --verbose /path to /myworkingdirectory/file.xlsx 

it lists the mime type and its value

I do not know what else to do to see the svn diff changes, as it can be seen in text format files

Answer 1

There are plugins for TortoiseSVN that allow you to distinguish between Office documents:

http://freemind.s57.xrea.com/xdocdiff/e/index.html

Answer 2

Xlsx is nothing more than a zip containing multiple XML files. SVN will not be able to distinguish them as text files, since they are binary.

Answer 3

If you have Windows & Office Professional Plus 2013 or Office 365 ProPlus, I recommend using Spreadsheet Compare, as it also analyzes the built-in xls history.

Name this little xlsdiff.bat from SNV:

 set path2=%1 set mine=%2 set mine=%mine:"=% ECHO %mine% > tmp.txt dir %path2% /B /S >> tmp.txt "C:\Program Files (x86)\Microsoft Office\Office15\DCF\SPREADSHEETCOMPARE.EXE" tmp.txt 

Configure svn to call "xlsdiff.bat% base% mine"