easyExcel下载Excel

加入依赖：

<dependency>

 <goupId>con.alibaba</groupId>

<artifactId>easyexcel</artifactId>

<version>2.2.6</version>

</dependency>

 

/**
*excelTitles ：excel的title
*dataList:数据集合
*clumnKey：key表示一行的第几个cell,value和IndicatorDataRespDTO的属性名对应
**/
private void loadExcelUtil(List<String> excelTitles ,List<IndicatorDataRespDTO dataList,
HashMap<Integer,String> clumnKey,HttpServletResponse response){
  //FileOutStream fs = null; 
  OutputStream os = null;//下载到浏览器端的流
  try{
    String date = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
    //服务器端下载
    //String fileName = "D:\\"+date+".xlsx";
    //fs = new FileOutputStream(new File(fileName));
   //浏览器端下载
    String fileName1 = date+&#