csv解析java_Java CSV解析器

csv解析java

Welcome to the Java CSV Parser tutorial. CSV files are one of the most widely used format to pass data from one system to another. Since CSV files are supported in Microsoft Excel, it can be easily used by non-techies also.

欢迎使用Java CSV解析器教程。 CSV文件是将数据从一个系统传递到另一个系统的最广泛使用的格式之一。 由于Microsoft Excel支持CSV文件，因此非技术人员也可以轻松使用它。

Java CSV解析器 (Java CSV Parser)

Unfortunately, we don’t have any in-built Java CSV Parser.

不幸的是，我们没有任何内置的Java CSV解析器。

If the CSV file is really simple and don’t have any special characters, then we can use Java Scanner class to parse CSV files but most of the times it’s not the case. Rather than writing complicated logic for parsing, it’s better to use open-source tools we have for parsing and writing CSV files.

如果CSV文件真的很简单并且没有任何特殊字符，那么我们可以使用Java Scanner类来解析CSV文件，但大多数情况下并非如此。 与其编写复杂的逻辑进行解析，不如使用我们拥有的用于解析和编写CSV文件的开源工具。

There are three open-source APIs for working with CSV.

有三种用于CSV的开源API。

1. OpenCSV
   OpenCSV
2. Apache Commons CSV
   Apache Commons CSV
3. Super CSV
   超级CSV

We will look into all these java CSV parsers one by one.

我们将一一研究所有这些Java CSV解析器。

Suppose we have a CSV file as:

假设我们有一个CSV文件，如下所示：

employees.csv

employees.csv

ID,Name,Role,Salary
1,Pankaj Kumar,CEO,"5,000USD"
2,Lisa,Manager,500USD
3,David,,1000USD

and we want to parse it to list of Employee object.

并且我们想将其解析为Employee对象的列表。

package com.journaldev.parser.csv;

public class Employee {

	private String id;
	private String name;
	private String role;
	private String salary;
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getRole() {
		return role;
	}
	public void setRole(String role) {
		this.role = role;
	}
	public String getSalary() {
		return salary;
	}
	public void setSalary(String salary) {
		this.salary = salary;
	}
	
	@Override
	public String toString(){
		return "ID="+id+",Name="+name+",Role="+role+",Salary="+salary+"\n";
	}
}

1. OpenCSV (1. OpenCSV)

We will see how we can use OpenCSV java parser to read CSV file to java object and then write CSV from java object. Download OpenCSV libraries from SourceForge Website and include it in the classpath.

我们将看到如何使用OpenCSV Java解析器将CSV文件读取到Java对象，然后从Java对象写入CSV。 从SourceForge网站下载OpenCSV库，并将其包含在类路径中。

If you are using Maven then include it with below dependency.

如果您使用的是Maven，则将其包含在以下依赖项中。