Java 导出Excel

1. springboot工程

引入依赖 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.17</version> </dependency>

2. 实现类

package com.example.demo.controller; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.OutputStream; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; /** * excel导出 */ @RestController @RequestMapping(value = "/excel") public class ExportExcelController { @RequestMapping(value = "/export") public void export(HttpServletResponse response) { List<String> headlist = new ArrayList<>(); headlist.add("姓名"); headlist.add("性别"); headlist.add("年龄"); List<List<String>> listList = new ArrayList<>(); List<String> first = new ArrayList<>(); first.add("fisher"); first.add("male"); first.add("18"); List<String> second = new ArrayList<>(); second.add("lily"); second.add("female"); second.add("18"); listList.add(first); listList.add(second); HSSFWorkbook hwb = this.expExcel(headlist, listList); this.outFile(hwb, response); } public HSSFWorkbook expExcel(List<String> head, List<List<String>> body) { //创建一个excel工作簿 HSSFWorkbook workbook = new HSSFWorkbook(); //创建一个sheet工作表 HSSFSheet sheet = workbook.createSheet("身份信息"); //创建第0行表头，再在这行里在创建单元格，并赋值 HSSFRow row = sheet.createRow(0); HSSFCell cell; for (int i = 0; i < head.size(); i++) { cell = row.createCell(i); cell.setCellValue(head.get(i));//设置值 } //将主体数据填入Excel中 for (int i = 0; i < body.size(); i++) { row = sheet.createRow(i + 1); for (int j = 0; j < head.size(); j++) { cell = row.createCell(j); if (body.get(i).size() > j) { cell.setCellValue(body.get(i).get(j));//设置值 } } } return workbook; } public void outFile(HSSFWorkbook workbook, HttpServletResponse response) { OutputStream os = null; try { //防止中文乱码 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String title = "表格" + sdf.format(new Date()) + ".xls"; String headStr = "attachment; filename=\"" + new String(title.getBytes("gb2312"), "ISO8859-1") + "\""; response.setContentType("octets/stream"); response.setContentType("APPLICATION/OCTET-STREAM"); response.setHeader("Content-Disposition", headStr); os = response.getOutputStream(); workbook.write(os); } catch (Exception e) { e.printStackTrace(); } finally { try { if (os != null) { os.close(); } } catch (IOException e) { e.printStackTrace(); } } } }

3. 启动项目，发起请求

4. 查看导出结果

代码下载地址https://gitee.com/fisher3652/exportDemo.git