java - Spring MVC AbstractXlsxView

Question

我尝试使用 Spring 的 AbstractXlsxView，但它仅提示下载 application/octet-stream 文件类型而不是 excel 文件。

ExcelBuilder.java

public class ExcelBuilder extends AbstractXlsxView {

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

        Sheet latePaymentsSheet = workbook
                .createSheet("Late Payments");
        setLatePaymentHeader(latePaymentsSheet);

        @SuppressWarnings("unchecked")
        Map<String, Object> map = (Map<String, Object>) model.get("map");
        @SuppressWarnings("unchecked")
        List<Map<String, Object>> latePaymentsList = (List<Map<String, Object>>) map
                .get("latePayments");

        setLatePaymentsRow(latePaymentsSheet, latePaymentsList);
    }

Controller.java

@RequestMapping(value = "/export", method = RequestMethod.GET)
public ModelAndView exportToExcel() {

    Map<String,Object> map = Dao.getData()

 return new ModelAndView("ExcelBuilder", "map", map);
}

Excel-view.xml

<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd">

    <bean id="ExcelBuilder" class="com.test.utility.ExcelBuilder">
    </bean>
</beans>

Answer 1

您可以更改 @RequestMapping 并添加 products 属性。

@RequestMapping(value = "/export", method = RequestMethod.GET, produces="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

参见here对于其他 Mime 类型。