【缘起:此前找了一通,没有找到免费又好用的Excel比对工具,而ExcelBDD需要把Excel文件存放到Git,因此迫切需要Excel比对工具。
最新升级到V1.3.3,因为git diff有变化,原来是git diff会修改文件名,现在不改了,导致老版DiffExcel失效】
DiffExcel is an open-source and text-based tool to compare Excel, it supports Git diff.
It looks like the below:

Pre-Requirement
- Microsoft Excel
- PowerShell, which is pre-installed in Windows10 and the later
Install
- Open PowerShell
- execute Install-Script -Name DiffExcel
2.1 if updating, execute Update-Script -Name DiffExcel
Direct Usage
In PowerShell, use below syntax:
DiffExcel OldExcelFilePath NewExcelFilePath
e.g. DiffExcel E:\Code\ExcelBDD\DiffExcel\Test\OldFile.xlsx E:\Code\ExcelBDD\DiffExcel\T

最低0.47元/天 解锁文章
1559

被折叠的 条评论
为什么被折叠?



