Java实现批量导入自定义

@ApiOperation(value = “下载排水户导入模板”)
@GetMapping(“/downloadTemplate”)
public void downloadTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {

    HSSFWorkbook workbook = new HSSFWorkbook();
    String sheetName = "Sheet1";
    HSSFSheet sheet1 = workbook.createSheet(sheetName);
    //添加表头
    String titleRow[] = {

// “社会统一信用编码”,“法人姓名”,“法人身份证号码”,“法人联系电话”,“联系人姓名”,“联系人身份证号码”,“联系人电话”,
// “企业名称”,“企业地址”,“地址坐标(经度,维度)”,“是否重点排水户”,“企业类型”,“行业类型”,“排放类型”,“设计排水量（m³/日）”,
// “许可排水量（m³/日）”,“许可排水水质等级”,“是否限制排放时间”,“排放时限开始时间”,“排放时限结束时间”,“污水去向”,“污水去向编码”,
// “许可证有效期起始时间”,“许可证有效期结束时间”,“许可证地址”,“许可证编号”,“排水总量（立方米/日）”,“用途”,“排水地点”,“排水口数量”,
// “用水总量（立方米/日）”,“自来水量（立方米/日）”,“自备水量（立方米/日）”,“生产污水量（立方米/日）”,“生活污水量（立方米/日）”,“排水口编号”,“组织机构代码证号”
“社会统一信用编码”,“企业名称”,“企业地址”,“行业类型”,“排水总量（立方米/日）”,“污水去向”,“许可证有效期起始时间”,“许可证有效期结束时间”
};
HSSFRow row = workbook.getSheet(sheetName).createRow(0); //创建第一行
for(short i = 0;i < titleRow.length;i++){
HSSFCell cell = row.createCell(i);
cell.setCellValue(titleRow[i]);
}
// String exampleRow[] = {“II_20200317_001”,“13019877233”,“联通”,“北京”,“在网”};
// HSSFRow row_2 = workbook.getSheet(sheetName).createRow(1); //创建第一行
// for(short i = 0;i < exampleRow.length;i++){
// HSSFCell cell = row_2.createCell(i);
// cell.setCellValue(exampleRow[i]);
// }
OutputStream output=response.getOutputStream();
response.reset();
response.setCharacterEncoding(“UTF-8”);
response.setHeader(“Content-disposition”, “attachment;filename=drainage.xls”);
log.info(“workbook:”+workbook);
response.setContentType(“application/vnd.ms-excel;charset=utf-8”);
workbook.write(output);
output.close();
}