首页 > 其他 > 详细

TortoiseSVN SPREADSHEET COMPARE 比较表格

时间:2015-12-02 20:47:22      阅读:1123      评论:0      收藏:0      [点我收藏+]

参考 https://github.com/kniklas/excomp/blob/master/excomp.bat

在svndiffviewer 修改 xlsx 的比较脚本 wscript.exe "E:\diff-xlsx-ssc.vbs" %base %mine //E:vbscript

vbs脚本

dim objArgs, objFileSystem, sBaseVer, sNewVer, sMessage, sBaseMessage, sNewMessage, bDiffers, sTempFile

sBaseFile = objArgs(0)
sNewFile = objArgs(1)

Set objFileSystem = CreateObject("Scripting.FileSystemObject")
If objFileSystem.FileExists(sBaseFile) = False Then
    MsgBox "File " + sBaseFile + " does not exist.  Cannot compare the files.", vbCritical, "File not found"
    Wscript.Quit 1
End If
If objFileSystem.FileExists(sNewFile) = False Then
    MsgBox "File " + sNewFile + " does not exist.  Cannot compare the files.", vbCritical, "File not found"
    Wscript.Quit 1
End If

‘ Compare file size
dim fBaseFile, fNewFile, fs, f
Set fBaseFile = objFileSystem.GetFile(sBaseFile)
Set fNewFile = objFileSystem.GetFile(sNewFile)
sTempFile = "E:\temp.txt"

‘Creat temp.txt for save path of 2 xlsx files
Set fs =Wscript.CreateObject("scripting.filesystemobject")
Set f = fs.CreateTextFile(sTempFile, 2, True)
f.WriteLine sBaseFile
f.WriteLine sNewFile
f.Close()

‘ Compare files using SPREADSHEETCOMPARE.Exe
Set WshShell = WScript.CreateObject("WScript.Shell")
exitStatus = WshShell.Run("SPREADSHEETCOMPARE e:\temp.txt", 0, True)

Wscript.Quit

  

TortoiseSVN SPREADSHEET COMPARE 比较表格

原文:http://www.cnblogs.com/micele/p/5014037.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!