如何使用git diff创建两个电子表格的可读差异？ [英] How do I create a readable diff of two spreadsheets using git diff?

问题描述

我们的源代码库中有很多电子表格（xls）。这些通常使用gnumeric或openoffice.org编辑，主要用于使用 dbUnit 为单元测试填充数据库。在我知道的xls文件中没有简单的方法，这使得合并非常单调和容易出错。

我试图将电子表格转换为XML和做一个常规的差异，但它真的觉得它应该是最后的手段。

我想和 git 一样对文本文件进行差异化（和合并）。我会怎么做，例如当发出 git diff ？

解决方案

我们的合作我们的测试输出excel工作簿。二进制差异不是一种选择。所以我们推出了我们自己的简单命令行工具。查看 ExcelCompare项目。事实上，这使得我们可以很好地自动化我们的测试。修补程序/功能请求非常欢迎！

We have a lot of spreadsheets (xls) in our source code repository. These are usually edited with gnumeric or openoffice.org, and are mostly used to populate databases for unit testing with dbUnit. There are no easy ways of doing diffs on xls files that I know of, and this makes merging extremely tedious and error prone.

I've tried to converting the spreadsheets to xml and doing a regular diff, but it really feels like it should be a last resort.

I'd like to perform the diffing (and merging) with git as I do with text files. How would I do this, e.g. when issuing git diff?

解决方案

We faced the exact same issue in our co. Our tests output excel workbooks. Binary diff was not an option. So we rolled out our own simple command line tool. Check out the ExcelCompare project. Infact this allows us to automate our tests quite nicely. Patches / Feature requests quite welcome!

这篇关于如何使用git diff创建两个电子表格的可读差异？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！