CSV工具类Demo

简单CSV工具代码

package demo;

import com.opencsv.CSVReader;
import com.opencsv.CSVWriter;
import com.opencsv.exceptions.CsvException;

import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;


public class CSVTest {

    public static void main(String[] args) {
        // 写入CSV文件示例
        List<String[]> dataToWrite = new ArrayList<>();
        dataToWrite.add(new String[]{"Name", "Age", "Country"});
        dataToWrite.add(new String[]{"Alice", "30", "USA"});
        dataToWrite.add(new String[]{"Bob", "25", "UK"});

        writeCSV("C:\\data\\test\\example.csv", dataToWrite);

        // 读取CSV文件示例
        List<String[]> dataRead = readCSV("C:\\data\\test\\example.csv");
        for (String[] row : dataRead) {
            System.out.println(String.join(", ", row));
        }
    }

    // 读取CSV文件
    public static List<String[]> readCSV(String filePath) {
        List<String[]> data = null;
        try (CSVReader csvReader = new CSVReader(new FileReader(filePath))) {
            data = csvReader.readAll();
        } catch (IOException | CsvException e) {
            e.printStackTrace();
        }
        return data;
    }

    // 写入CSV文件
    public static void writeCSV(String filePath, List<String[]> data) {
        try (CSVWriter csvWriter = new CSVWriter(new FileWriter(filePath))) {
            csvWriter.writeAll(data);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

}