在SpringBoot:SpringBoot里面创建导出Excel的接口教程

 org.apache.poi
 poi
 3.17

import org.apache.poi.hssf.usermodel.*;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@Controller
public class ExcelController {

 /**
 * Excel表格导出接口
 * http://localhost:8080/ExcelDownload
 * @param response response对象
 * @throws IOException 抛IO异常
 */
 @RequestMapping("/ExcelDownload")
 public void excelDownload(HttpServletResponse response) throws IOException {
 //表头数据
 String[] header = {"ID", "姓名", "性别", "年龄", "地址", "分数"};

 //数据内容
 String[] student1 = {"1", "小红", "女", "23", "成都青羊区", "96"};
 String[] student2 = {"2", "小强", "男", "26", "成都金牛区", "91"};
 String[] student3 = {"3", "小明", "男", "28", "成都武侯区", "90"};

 //声明一个工作簿
 HSSFWorkbook workbook = new HSSFWorkbook();

 //生成一个表格，设置表格名称为"学生表"
 HSSFSheet sheet = workbook.createSheet("学生表");

 //设置表格列宽度为10个字节
 sheet.setDefaultColumnWidth(10);

 //创建第一行表头
 HSSFRow headrow = sheet.createRow(0);

 //遍历添加表头(下面模拟遍历学生，也是同样的操作过程)
 for (int i = 0; i 

import org.apache.poi.hssf.usermodel.*;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * Excel工具类
 */
public class ExcelUtil {

 /**
 * Excel表格导出
 * @param response HttpServletResponse对象
 * @param excelData Excel表格的数据，封装为List>
 * @param sheetName sheet的名字
 * @param fileName 导出Excel的文件名
 * @param columnWidth Excel表格的宽度，建议为15
 * @throws IOException 抛IO异常
 */
 public static void exportExcel(HttpServletResponse response,
     List> excelData, 
     String sheetName, 
     String fileName, 
     int columnWidth) throws IOException {

 //声明一个工作簿
 HSSFWorkbook workbook = new HSSFWorkbook();

 //生成一个表格，设置表格名称
 HSSFSheet sheet = workbook.createSheet(sheetName);

 //设置表格列宽度
 sheet.setDefaultColumnWidth(columnWidth);

 //写入List>中的数据
 int rowIndex = 0;
 for(List data : excelData){
  //创建一个row行，然后自增1
  HSSFRow row = sheet.createRow(rowIndex++);

  //遍历添加本行数据
  for (int i = 0; i 
/**
 * Excel表格导出接口
 * http://localhost:8080/ExcelDownload
 * @param response response对象
 * @throws IOException 抛IO异常
 */
@RequestMapping("/ExcelDownload")
public void excelDownload(HttpServletResponse response) throws IOException {

 List> excelData = new ArrayList<>();

 List head = new ArrayList<>();
 head.add("第一列");
 head.add("第二列");
 head.add("第三列");

 List data1 = new ArrayList<>();
 data1.add("123");
 data1.add("234");
 data1.add("345");

 List data2 = new ArrayList<>();
 data2.add("abc");
 data2.add("bcd");
 data2.add("cde");

 excelData.add(head);
 excelData.add(data1);
 excelData.add(data2);

 String sheetName = "测试";
 String fileName = "ExcelTest.xls";

 ExcelUtil.exportExcel(response, excelData, sheetName, fileName, 15);
}