package com.gps.csv;
import com.opencsv.CSVReader;
import java.io.*;
import java.nio.charset.StandardCharsets;
import java.util.ArrayList;
import java.util.List;
public class Main {
public static void main(String[] args) {
String csvFile = "D:\\Adesk\\systemFile\\CSV\\#1#28#49\\04#1.csv";
String [] line ;
List<String> column3List = new ArrayList<>();
List<String> column4List = new ArrayList<>();
try (BufferedReader reader = new BufferedReader(new InputStreamReader(new FileInputStream(csvFile), "GBK"));
CSVReader csvReader = new CSVReader(reader)) {
// 读取文件头行
String[] header = csvReader.readNext();
// 找到第三列和第四列的索引
int column3Index =-1;
int column4Index = -1;
for (int i = 0; i < header.length; i++) {
if (header[i].equals("舱外温度(℃)")) {
column3Index = i;
} else if (header[i].equals("时间")) {
column4Index = i;
}
}
// 读取每一行数据
while ((line = csvReader.readNext()) != null) {
// 提取第三列和第四列的数据
if (column3Index != -1) {
column3List.add(line[column3Index]);
}
if (column4Index != -1) {
column4List.add(line[column4Index]);
}
}
System.out.println(column3List);
System.out.println("--------------------------");
System.out.println(column4List);
} catch (Exception e) {
e.printStackTrace();
}
}
}
pom.xml
<dependency>
<groupId>com.opencsv</groupId>
<artifactId>opencsv</artifactId>
<version>5.5.2</version>
</dependency>