Spring 下载 Excel (最简单)

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.view.document.AbstractXlsView;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Map;

@RestController
public class ExcelController {
    
    @GetMapping("/excel")
    public AbstractXlsView excel(){
        AbstractXlsView xls = new AbstractXlsView() {
            @Override
            protected void buildExcelDocument(Map<String, Object> map, org.apache.poi.ss.usermodel.Workbook workbook, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception {

                Sheet sheet = workbook.createSheet("testExcel");
                for (int i = 0; i < 5; i++) {
                    Row row = sheet.createRow(i);
                    for (int j = 0; j < 10; j++) {
                        Cell cell = row.createCell(j);
                        cell.setCellValue(i+":"+j);
                    }
                }
            }
        };
        return xls;
    }
}

直接复制便可用

效果：

spring 版本

@since 4.2