如何使用java从多个csv文件中输入数据

Question

我有一些相同列标题的CSV文件。我想把它们做成一个文件。所以我找到了和我相似的东西。链接是将CSV文件合并到一个没有重复标题的文件中。但是我想以字符串的形式返回数据，但是这段代码没有返回。我试着修改一下。但我失败了。我想把来自多个csv的数据放到一个变量中。

String[] headers = null;
String firstFile = "/path/to/firstFile.dat";
Scanner scanner = new Scanner(new File(firstFile));

if (scanner.hasNextLine())
    headers[] = scanner.nextLine().split(",");

scanner.close();

Iterator<File> iterFiles = listOfFilesToBeMerged.iterator();
BufferedWriter writer = new BufferedWriter(new FileWriter(firstFile, true));

while (iterFiles.hasNext()) {
  File nextFile = iterFiles.next();
  BufferedReader reader = new BufferedReader(new FileReader(nextFile));

  String line = null;
  String[] firstLine = null;
  if ((line = reader.readLine()) != null)
    firstLine = line.split(",");

  if (!Arrays.equals (headers, firstLine))
    throw new FileMergeException("Header mis-match between CSV files: '" +
              firstFile + "' and '" + nextFile.getAbsolutePath());

  while ((line = reader.readLine()) != null) {
    writer.write(line);
    writer.newLine();
  }

  reader.close();
}
writer.close();

Answer 1

另一种选择是使用Open CSV库

Answer 2

这是你可能要找的。我读了两个csv文件，并写入其中一个。希望这是充分利用。。。

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;

public class CombineTwoFile
{
       public static void main(String[] args) throws IOException
       {      
       ArrayList<String> list = new ArrayList<String>();
       try
       {
       BufferedReader br = new BufferedReader(new FileReader( "d:\\1\\1.csv"));
         BufferedReader r = new BufferedReader(new FileReader( "d:\\1\\2.csv"));
            String s1 =null;
            String s2 = null;

                         while ((s1 = br.readLine()) != null)
                         {                         
                                        list.add(s1);        
                         }
                         while((s2 = r.readLine()) != null)
                         {    
                                        list.add(s2);    
                         } 
       }
        catch (IOException e)
          {
            e.printStackTrace();
          }

           BufferedWriter writer=null;
           writer = new BufferedWriter(new FileWriter("d:\\1\\good.csv"));
            String listWord;              
                   for (int i = 0; i< list.size(); i++)
                  {
                        listWord = list.get(i);
                       writer.write(listWord);
                       writer.write("\n");
                  }
                           System.out.println("DONE Enjoy!!");
                           writer.close();    
        }
    }

或者，如果您正在寻找一个返回String并结合两个csv的函数

public static String combineCSV() {
        ArrayList<String> list = new ArrayList<String>();
        try {
            BufferedReader br = new BufferedReader(new FileReader(
                    "d:\\1\\1.csv"));
            BufferedReader r = new BufferedReader(
                    new FileReader("d:\\1\\2.csv"));
            String s1 = null;
            String s2 = null;

            while ((s1 = br.readLine()) != null) {
                list.add(s1);
            }
            while ((s2 = r.readLine()) != null) {
                list.add(s2);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }

        String listWord;
        StringBuffer objBuffer = new StringBuffer();
        for (int i = 0; i < list.size(); i++) {
            listWord = list.get(i);

            objBuffer.append(listWord);
            objBuffer.append("\n");

        }
        System.out.println("DONE Enjoy!!");
        System.out.println(objBuffer);
        return objBuffer.toString();
    }

非常感谢。享受编码。。。