Spring MVC附带AbstractExcelView类,可通过Apache POI库将数据导出到Excel文件。 在本教程中,它演示了Spring MVC应用程序中AbstractExcelView类的使用,该数据将数据导出到Excel文件以供下载。
1. Apache POI
获取Apache POI库以创建excel文件。
<!-- Excel library -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.6</version>
</dependency>
2.控制器
控制器类,生成虚拟数据进行演示,并获取请求参数以确定要返回的视图。 如果request参数等于“ EXCEL”,则返回一个Excel视图( AbstractExcelView )。
文件:RevenueReportController.java
package com.mkyong.common.controller;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.bind.ServletRequestUtils;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;
public class RevenueReportController extends AbstractController{
@Override
protected ModelAndView handleRequestInternal(HttpServletRequest request,
HttpServletResponse response) throws Exception {
String output =
ServletRequestUtils.getStringParameter(request, "output");
//dummy data
Map<String,String> revenueData = new HashMap<String,String>();
revenueData.put("Jan-2010", "$100,000,000");
revenueData.put("Feb-2010", "$110,000,000");
revenueData.put("Mar-2010", "$130,000,000");
revenueData.put("Apr-2010", "$140,000,000");
revenueData.put("May-2010", "$200,000,000");
if(output ==null || "".equals(output)){
//return normal view
return new ModelAndView("RevenueSummary","revenueData",revenueData);
}else if("EXCEL".equals(output.toUpperCase())){
//return excel view
return new ModelAndView("ExcelRevenueSummary","revenueData",revenueData);
}else{
//return normal view
return new ModelAndView("RevenueSummary","revenueData",revenueData);
}
}
}
3. AbstractExcelView
通过扩展AbstractExcelView类来创建Excel视图,并重写buildExcelDocument()方法以将数据填充到Excel文件中。 AbstractExcelView使用Apache POI API创建Excel文件详细信息。
注意
有关如何使用Apache POI的详细信息,请参阅Apache POI文档。
文件:ExcelRevenueReportView.java
package com.mkyong.common.view;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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.servlet.view.document.AbstractExcelView;
public class ExcelRevenueReportView extends AbstractExcelView{
@Override
protected void buildExcelDocument(Map model, HSSFWorkbook workbook,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
Map<String,String> revenueData = (Map<String,String>) model.get("revenueData");
//create a wordsheet
HSSFSheet sheet = workbook.createSheet("Revenue Report");
HSSFRow header = sheet.createRow(0);
header.createCell(0).setCellValue("Month");
header.createCell(1).setCellValue("Revenue");
int rowNum = 1;
for (Map.Entry<String, String> entry : revenueData.entrySet()) {
//create the row data
HSSFRow row = sheet.createRow(rowNum++);
row.createCell(0).setCellValue(entry.getKey());
row.createCell(1).setCellValue(entry.getValue());
}
}
}
注意
或者,您可以使用AbstractJExcelView ,它使用JExcelAPI创建相同的Excel视图,请参见此AbstractJExcelView示例 。
4.弹簧配置
为Excel视图创建XmlViewResolver 。
<beans ...>
<bean
class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping" />
<bean class="com.mkyong.common.controller.RevenueReportController" />
<bean class="org.springframework.web.servlet.view.XmlViewResolver">
<property name="location">
<value>/WEB-INF/spring-excel-views.xml</value>
</property>
</bean>
</beans>
文件:spring-excel-views.xml
<bean id="ExcelRevenueSummary"
class="com.mkyong.common.view.ExcelRevenueReportView">
</bean>
5.演示
网址: http:// localhost:8080 / SpringMVC / revenuereport.htm?output = excel
它生成一个供用户下载的Excel文件。
下载源代码
下载它– SpringMVC-ExcelFile-AbstractExcelView-Example.zip (9KB)
参考文献
- Apache POI
- 摘要ExcelView Javadoc
- Spring MVC通过AbstractJExcelView将数据导出到Excel文件
- Spring MVC XmlViewResolver示例
翻译自: https://mkyong.com/spring-mvc/spring-mvc-export-data-to-excel-file-via-abstractexcelview/