当前位置 博文首页 > lenkee的博客:OpenCSV创建csv文件
<dependency>
<groupId>com.opencsv</groupId>
<artifactId>opencsv</artifactId>
<version>4.1</version>
</dependency>
public static void writeDataLineByLine(String filePath)
{
File file = new File(filePath);
try {
FileWriter outputfile = new FileWriter(file);
CSVWriter writer = new CSVWriter(outputfile);
// 添加头
String[] header = { "Name", "Class", "Marks" };
writer.writeNext(header);
// 插入数据
String[] data1 = { "Aman", "10", "620" };
writer.writeNext(data1);
String[] data2 = { "Suraj", "10", "630" };
writer.writeNext(data2);
writer.close();
}
catch (IOException e) {
e.printStackTrace();
}
}
public void exportCSV(List<List<String>> dealData) throws IOException {
try {
response.setContentType("text/csv");
response.setHeader("Content-Disposition", "attachment; filename=\"customer-emails.csv\"");
PrintWriter printWriter = response.getWriter();
CSVWriter writer = new CSVWriter(printWriter, ';');
dealData.stream().forEach(list ->{
String[] array = list.toArray(new String[list.size()]);
writer.writeNext(array);
});
// closing writer connection
writer.flush();
writer.close();
}
catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
cs