excel比较两列不同

来源：互联网发布：淘宝平均停留时长编辑：程序博客网时间：2024/06/05 19:59

第一种方式，写一个比较不同文件的一个功能：其原理是，把A文件的内容转换成数组，然后B文件比较，有A文件的内容就剔除，剩下的就是不在A文件的内容了，然后将这些保存在diff.txt中。。。

package com.jd.finance.xjk.op.test;import java.io.*;import java.util.HashMap;import java.util.Map;/** * Created by wangxingjie on 2016/10/21. */public class FileCompDiff {        public static void main(String[] strings) throws IOException {            File daifu=new File("E:\\test\\daifu.txt");            File xiaojink=new File("E:\\test\\小金库发奖.txt");            File diff=new File("E:\\test\\diff.txt");            BufferedReader fileInputStreamDaifu=null;            BufferedReader fileInputStreamXiaojink=null;            BufferedWriter out=null;            try {                fileInputStreamDaifu= new BufferedReader(new InputStreamReader(new FileInputStream(daifu),"utf-8"));                fileInputStreamXiaojink= new BufferedReader(new InputStreamReader(new FileInputStream(xiaojink),"utf-8"));                out= new BufferedWriter(new OutputStreamWriter(new FileOutputStream(diff),"utf-8"));                String line1=null;                String line2=null;                Map<String,String> mapRead=new HashMap<String, String>(35000);                while ((line1=fileInputStreamXiaojink.readLine())!=null){                    String[] segments1 = line1.split("\t");                    mapRead.put(segments1[0],line1+"\n");                }                while ((line2=fileInputStreamDaifu.readLine())!=null){                    String[] segments2 = line2.split("\t");                    if (null!=mapRead.get(segments2[0])){                        mapRead.remove(segments2[0]);                    }                }                System.out.println("匹配到的数据条数为 ："+mapRead.size());                for (String key :mapRead.keySet()){                    out.write(mapRead.get(key));                }            } catch (FileNotFoundException e) {                e.printStackTrace();            } catch (IOException e) {                e.printStackTrace();            }finally {                fileInputStreamDaifu.close();                fileInputStreamXiaojink.close();                out.close();            }        }}

最后的文件diff.txt是比较不同的结果文件。

第二种方法是：利用方法=COUNTIF(B:B,A1)即可得到0或者1,0代表的是不同，在通过筛选得到不通的数据

见：http://jingyan.baidu.com/article/c843ea0b7a2a7477921e4a47.html

1 0