SpringMVC学习--自定义Excel视图

最新推荐文章于 2021-03-17 20:34:40 发布

BrotherBaby

最新推荐文章于 2021-03-17 20:34:40 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： spring mvc 文章标签： spring mvc

本文链接：https://blog.youkuaiyun.com/h670816026/article/details/76099527

spring mvc 专栏收录该内容

2 篇文章

订阅专栏

本文详细探讨了在SpringMVC中如何实现自定义的Excel视图。通过控制器部分的设置和配置文件springmvc-config.xml的调整，阐述了生成并返回Excel文件的方法，为读者提供了一个完整的工作流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

// 省略各种导包......  

/** 
 * 原先继承的是AbstractExcelView,但是已经过时了,打开源码,推荐使用 
 * AbstractXlsView / AbstractXlsxView / AbstractXlsxStreamingView 
 * 
 */  
public class ExportExcelViewResolver extends AbstractXlsView {  

    @Override  
    protected void buildExcelDocument(Map<String, Object> model, Workbook workbook, HttpServletRequest request,  
            HttpServletResponse response) throws Exception {  

        String fileName = "下载列表.xls";  
        response.setCharacterEncoding("UTF-8");  
        response.setContentType("application/ms-excel");// 文件下载  
        response.setHeader("Content-Disposition", "inline; filename=" + new String(fileName.getBytes(), "iso8859-1"));  
        OutputStream outputStream = response.getOutputStream();  

        HSSFWorkbook book = (HSSFWorkbook) workbook;  
        HSSFSheet sheet = book.createSheet();  

        HSSFRow row = sheet.createRow(0);  
        String[] headers = new String[] { "编号", "姓名", "年龄" };  
        for (int i = 0; i < headers.length; i++) {  
            row.createCell(i).setCellValue(headers[i]);  
        }  

        List<Student> stuList = (List<Student>) model.get("stuList");  
        for (int i = 0; i < stuList.size(); i++) {  
            Student stu = stuList.get(i);  

            row = sheet.createRow(i + 1);  
            row.createCell(0).setCellValue(i + 1);  
            row.createCell(1).setCellValue(stu.getName());  
            row.createCell(2).setCellValue(stu.getAge());  
        }  

        book.write(outputStream);  
        outputStream.flush();  
        outputStream.close();  

    }  
}

controller部分:

@Controller  
@RequestMapping("/system")  
public class ExportExcelViewController {  

    @RequestMapping("/excel.do")  
    public String Excel(ModelMap map){  

        List<Student> stuList = new ArrayList<>();  

        Student stu = new Student();  
        stu.setName("zs1");  
        stu.setAge(27);  
        stuList.add(stu);  

        stu = new Student();  
        stu.setName("zs2");  
        stu.setAge(28);  
        stuList.add(stu);  

        stu = new Student();  
        stu.setName("zs3");  
        stu.setAge(29);  
        stuList.add(stu);  

        map.put("stuList", stuList);  

        return "exportExcel";  
    }  
}

springmvc-config.xml 部分:

<!-- 注册excel视图解析器 -->  
<bean class="org.springframework.web.servlet.view.BeanNameViewResolver" />  
<bean id="exportExcel" class="com.abc.crm.commons.web.filter.ExportExcelViewResolver" />