1,在根目录C:\Users\user.m2\localRepository\ 下 创建Javascv文件夹 ---->再创建Javascv文件夹----->
再创建2.1文件夹 ---->最后把Javascv2.1.jar放到2.1文件夹下
创建文件Javascv2.1.pom,内容如下
<project>
<modelVersion>1.0.0</modelVersion>
<groupId>Javascv</groupId>
<artifactId>Javascv</artifactId>
<version>2.1</version>
</project>
2,在你的项目的pom.xml依赖中引入就行了
<dependency>
<groupId>Javascv</groupId>
<artifactId>Javascv</artifactId>
<version>2.1</version>
</dependency>
3 代码实现
3.1 读操作
public static void read(){
String filePath = "XXX.csv";
try {
// 创建CSV读对象
CsvReader csvReader = new CsvReader(filePath);
// 读表头
csvReader.readHeaders();
while (csvReader.readRecord()){
// 读一整行
System.out.println(csvReader.getRawRecord());
// 读这行的某一列
System.out.println(csvReader.get("Link"));
}
} catch (IOException e) {
e.printStackTrace();
}
}
3.2 写操作
public static void write(){
String filePath = "/Users/dddd/test.csv";
try {
// 创建CSV写对象
CsvWriter csvWriter = new CsvWriter(filePath,',', Charset.forName("GBK"));
//CsvWriter csvWriter = new CsvWriter(filePath);
// 写表头
String[] headers = {"编号","姓名","年龄"};
String[] content = {"12365","张山","34"};
csvWriter.writeRecord(headers);
csvWriter.writeRecord(content);
csvWriter.close();
} catch (IOException e) {
e.printStackTrace();
}
}