关于比较两张excel表 [英] Regarding comparing two excel sheets

问题描述

我正在从文本文件生成excel文件，现在我想根据内容比较2个excel文件，并希望通过对rowetc进行颜色更改来突出显示更新的内容。有人可以提出一些想法可以做些什么吗？Anyhelp会非常感激..提前谢谢

I am generating excel file from text file,now i want to compare 2 excel files based on their content and want to highlight the updated content by making colour changing of the rowetc. Can someone suggest some sort of idea how ths can be done???Anyhelp would be really appreciated..thanks in advance

推荐答案

可能的步骤：

1.阅读文本文件

2.使用POI api读取old_excel文件。

3.在文本文件的基础上使用POI创建new_excel实例

4.在编写之前，即在创建时将其与old_excel文件进​​行比较

5.进行必要的更新，即POI实例上的行颜色/列颜色更改

6.最后写下来。

Probable Steps :
1. Read the text file
2. Read the old_excel file using POI api.
3. On the basis of text file create an new_excel instance using POI
4. before writing it i.e at the time of creation compare it with old_excel file
5. do the necessary update i.e. row color/column color change on the POI instance
6. finally write it.

这篇关于关于比较两张excel表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！