OpenCSV web下载csv文件demo

OpenCSV web下载csv文件demo
pom.xml

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

	@RequestMapping(value = "/batchScan!exportReport.action")
	public void exportReport(HttpServletRequest request, HttpServletResponse response) {
		try {
			response.setContentType("text/csv");
			response.setCharacterEncoding("utf-8");
			String fileName = URLEncoder.encode("测试", "UTF-8").replaceAll("\\+", "%20");
			response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".csv");
			
			PrintWriter printWriter = response.getWriter();
			CSVWriter writer = new CSVWriter(printWriter, ',');
			List<DemoData> data = data();

			SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			String[] header = new String[]{"字符串", "日期", "数据"};
			writer.writeNext(header);
			for (DemoData demoData : data) {
				String[] array = new String[3];
				array[0] = demoData.getString();
				array[1] = dateFormat.format(demoData.getDate());
				array[2] = demoData.getDoubleData().toString();
				writer.writeNext(array);
			}
			writer.flush();
			writer.close();
			request.getSession().setAttribute("exportIsEnd", "true");
		} catch (Exception e) {
			request.getSession().setAttribute("exportIsEnd", "exception");
			e.printStackTrace();
		}
	}

产生数据

    public List<DemoData> data() {
        List<DemoData> list = new ArrayList<DemoData>();
        for (int i = 0; i < 10; i++) {
            DemoData data = new DemoData();
            data.setString("字符串" + i);
            data.setDate(new Date());
            data.setDoubleData(0.56);
            list.add(data);
        }
        return list;
    }

实体类

public class DemoData {
    private String string;
    private Date date;
    private Double doubleData;
    //get,set方法省略
}

参考:https://blog.csdn.net/haqiang555/article/details/97942797

EasyExcel web下载excel参见:https://blog.csdn.net/weixin_43614067/article/details/116262853

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值