java 逐行写入csv_每行写入新的CSV文件(JAVA)

我有以下代码：

public static void main(String[] args) throws IOException {

//File being read:

String fileName = "src/data/Belgium.csv";

String[] nextLine;

try (CSVReader reader = new CSVReader(new FileReader(fileName), ',', '"', 1)) {

while ((nextLine = reader.readNext()) != null) {

for (String line : nextLine) {

//NewFile

//When 2nd parameter - ture, it gets so big, that excel can't handle it anymore...

FileWriter writer = new FileWriter("src/dataNew/BelgiumNew1.csv", true);

line = line.replaceAll("T", " ");

line = line.replaceAll("Z", "");

line = line.replaceAll("ActualGenerationPerUnit.mean", "");

line = line.replaceAll("Plantname:", "");

//Escaping curly braces is a must!

line = line.replaceAll("\{", "");

line = line.replaceAll("\}", "");

writer.append(line);

writer.flush();

writer.close();

System.out.println(line);

}

}System.out.println("Successfully written");

}

}

在控制台中,使用System.out.println(line)输出的代码为我提供了正确的输出.

但是,当我打开CSV文件时,它似乎是反向写入的.

Excel首先抱怨行数.

但是,仅显示原始数据集的最后一行.

数据集(以一种低效的方式进行了预处理)包含1000多个行.因此,我不能简单地附加每个条目.

有更好的方法吗？

提示和技巧非常受欢迎.

更进一步,我尝试了几位作家：

-CSVwrite

-BufferedWriter

-FileWriter

还检查了关于Stackoverflow的其他问题…

似乎无法使其正常工作.谢谢！

更新：

问题得到解答！最终代码：

public static void main(String[] args) throws IOException {

//File being read:

String fileName = "src/data/Belgium.csv";

//When 2nd parameter - ture, it gets so big, that excel can't handle it anymore...

FileWriter writer = new FileWriter("src/dataNew/BelgiumNew5.csv", true);

String[] nextLine;

try (CSVReader reader = new CSVReader(new FileReader(fileName), ',', '"', 1)) {

while ((nextLine = reader.readNext()) != null) {

for (String line : nextLine) {

line = line.replaceAll("T", " ");

line = line.replaceAll("Z", "");

line = line.replaceAll("ActualGenerationPerUnit.mean", "");

line = line.replaceAll("Plantname:", "");

//Escaping curly braces is a must!

line = line.replaceAll("\{", "");

line = line.replaceAll("\}", "");

writer.append(line);

writer.append(System.lineSeparator());

System.out.println(line);

}

}System.out.println("Successfully written");

}catch(Exception e){

e.printStackTrace();

}finally {

if (writer != null){

writer.flush();

writer.close();

}

}

}