Java根据某一字段合并两个 Excel文件

两个Excel表根据时间字段合并在一起：


代码如下：

package com.tyut.rcr;import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileWriter;import java.io.InputStreamReader;import java.util.ArrayList;import java.util.Iterator;import java.util.List;public class test {        public static void main(String[] args) throws Exception {            String inputPath1="C:\\Users\\REN\\Desktop\\2016.08.MD.csv";            String inputPath2="C:\\Users\\REN\\Desktop\\2016.08.AQI.csv";            String outputPath="C:\\Users\\REN\\Desktop\\2016.08.AQIMD.csv";            List<String> a1 = readCsv1(inputPath1);            List<String> a2 = readCsv1(inputPath2);            List<String> a3 = new ArrayList<String>();            FileWriter fileWriter = new FileWriter(outputPath,true);            Iterator<String> iterable =a2.iterator();            while(iterable.hasNext()){                String str = iterable.next();                Iterator<String> iterable1 =a1.iterator();                while(iterable1.hasNext()){                    String st2 = iterable1.next();                    if(str.split(",")[7].equals(st2.split(",")[0])){                        a3.add(str+","+st2+"\n");                    }                }            }            Iterator<String> iterable2 =a3.iterator();            while(iterable2.hasNext()){                String a = iterable2.next();                fileWriter.write(a);            }            fileWriter.close();        }        public static List<String> readCsv1(String path) throws Exception{            File file2= new File(path);            InputStreamReader iread2 = new InputStreamReader(new FileInputStream(path));            List<String> list = new ArrayList<>();            BufferedReader bufferedReader2 = new BufferedReader(iread2);            String line2=null;            while((line2=bufferedReader2.readLine())!=null){                list.add(line2);            }            iread2.close();            bufferedReader2.close();            return list;            }}