针对java的csv文件读写,需要引入javacsv.jar。
代码实例:
package test;
import java.io.IOException;
import java.nio.charset.Charset;
import com.csvreader.CsvReader;
import com.csvreader.CsvWriter;
/**
* csv文件读写工具
* @author hp
*
*/
public class CSVUtil {
/**
*
* 读取csv文件
* @param csvFilePath 文件路径
*/
public static void readCSV(String csvFilePath){
CsvReader reader = null;
try {
reader = newCsvReader(csvFilePath,',',Charset.forName("gbk"));
reader.readHeaders(); // 跳过表头
while(reader.readRecord()){ //逐行读入除表头的数据
for(String str:reader.getValues()){
System.out.print(str+",");
}
}
}catch(Exception ex){
System.out.println(ex);
}finally{
reader.close();
}
}
/**
*
* 写入csv文件
* @param csvFilePath 文件路径
*/
public static void writeCsv(String csvFilePath,String[] content){
CsvWriter wr = null;
try {
wr =new CsvWriter(csvFilePath,',',Charset.forName("gbk"));
//换行
wr.writeRecord(content,true);
wr.flush();
System.out.println("写入完毕");
} catch (IOException e) {
e.printStackTrace();
}finally{
wr.close();
}
}
public static void main(String[] args) {
String srcCSV = "E:/test.csv";
String[] contents = {"13639050734","王进军","wangjinjun"};
writeCsv(srcCSV,contents);
readCSV(srcCSV);
}
}