通过AbstractJExcelView的Spring MVC和Excel文件

Spring MVC附带AbstractJExcelView类，可通过JExcelAPI库将数据导出到Excel文件。 在本教程中，它展示了如何在Spring MVC应用程序中使用AbstractJExcelView类将数据导出到Excel文件进​​行下载。

1. JExcelAPI

获取JExcelAPI库 。

<!-- JExcelAPI library --> 
    <dependency>
	<groupId>net.sourceforge.jexcelapi</groupId>
	<artifactId>jxl</artifactId>
	<version>2.6.3</version>
    </dependency>

2.控制器

控制器类，生成虚拟数据进行演示，并获取请求参数以确定要返回的视图。 如果request参数等于“ EXCEL”，则返回一个Excel视图（ AbstractJExcelView ）。

文件：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. AbstractJExcelView

通过扩展AbstractJExcelView类来创建Excel视图，并重写buildExcelDocument（）方法以将数据填充到Excel文件中。 AbstractJExcelView正在使用 JExcelAPI创建Excel文件的详细信息。

注意
有关如何使用JExcelAPI的详细信息，请参考JExcelAPI文档。

文件：ExcelRevenueReportView.java

package com.mkyong.common.view;

import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.springframework.web.servlet.view.document.AbstractJExcelView;

public class ExcelRevenueReportView extends AbstractJExcelView{

	@Override
	protected void buildExcelDocument(Map model, WritableWorkbook workbook,
	   HttpServletRequest request, HttpServletResponse response)
	   throws Exception {

	   Map<String,String> revenueData = (Map<String,String>) model.get("revenueData");
	   WritableSheet sheet = workbook.createSheet("Revenue Report", 0);
		
           sheet.addCell(new Label(0, 0, "Month"));
           sheet.addCell(new Label(1, 0, "Revenue"));

           int rowNum = 1;
	   for (Map.Entry<String, String> entry : revenueData.entrySet()) {
		//create the row data
		sheet.addCell(new Label(0, rowNum, entry.getKey()));
	        sheet.addCell(new Label(1, rowNum, entry.getValue()));
	        rowNum++;
           }
       }
}

注意
或者，您可以使用AbstractExcelView ，它使用Apache POI API创建相同的Excel视图，请参见此AbstractExcelView示例 。

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

<beans ...">
 
   <bean id="ExcelRevenueSummary"
   	class="com.mkyong.common.view.ExcelRevenueReportView">
   </bean>
 
</beans>

5.演示

网址： http：// localhost：8080 / SpringMVC / revenuereport.htm？output = excel

它生成一个供用户下载的Excel文件。

下载源代码

下载它– SpringMVC-ExcelFile-AbstractJExcelView-Example.zip （9KB）

参考文献

1. JExcelAPI文档
2. 抽象JExcelView Javadoc
3. Spring MVC通过AbstractExcelView将数据导出到Excel文件

标签： Excel Spring MVC

翻译自: https://mkyong.com/spring-mvc/spring-mvc-export-data-to-excel-file-via-abstractjexcelview/