OpenCSV创建csv文件

最新推荐文章于 2025-06-03 09:41:47 发布

lenKee

最新推荐文章于 2025-06-03 09:41:47 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

文章标签： CSV文件下载 opencsv

本文链接：https://blog.youkuaiyun.com/haqiang555/article/details/97942797

本文介绍如何使用Java的OpenCSV库进行CSV文件的创建、数据写入及从Web应用中导出。通过示例代码，展示了如何定义依赖、创建CSV文件、添加头信息和数据，以及如何从Java Web应用中导出CSV文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

导入依赖包

<dependency> 
	<groupId>com.opencsv</groupId> 
	<artifactId>opencsv</artifactId> 
	<version>4.1</version> 
</dependency>

创建csv文件

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(); 
    } 
}

javaweb导出csv文件

  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();
    }
  }