| 注意: 1. 模板需放在 WEB-INF 目录下 2. 指定模板路径时不需要添加扩展名, Spring将自动添加 .xls 到URL 属性中. 3. 在指定URL前需先设置 view 的 ApplicationContext |
1. 控制器配置 control-context.xml
1 <bean id="beanNameViewResolver"
2 class="org.springframework.web.servlet.view.BeanNameViewResolver" />
3
4 <bean id="viewController" class="ViewController">
5 <property name="dataModel">
6 <ref bean="model-DataModel"/>
7 </property>
8 </bean>
9
10 <bean id="urlMapping"
11 class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
12 <property name="mappings">
13 <props>
14 <prop key="/view/*.report">viewController</prop>
15 </props>
16 </property>
17 </bean>
2. Excel视图子类化 ExcelView.java
实现 org.springframework.web.servlet.view.document.AbstractExcelView 类中的 buildExcelDocument方法。
1 public class ExcelView extends AbstractExcelView {
2
3 protected void buildExcelDocument(Map<String, Object> model,
4 HSSFWorkbook wb, HttpServletRequest request, HttpServletResponse reqponse)
5 throws Exception {
6
7 //...
8 Object[] datas = (Object[]) model.get("data");
9 //...
10
11 HSSFSheet sheet;
12 //get the sheet 1 in template
13 sheet = wb.getSheetAt(0);
14 //handle this sheet
15 //...
16 }
17 }
3. 控制器 ViewController ViewController.java
1 public class ViewController extends MultiActionController {
2
3 private DataModel dataModel;
4
5 public void setDataModel(DataModel dataModel){
6 this.dataModel = dataModel;
7 }
8
9 public ModelAndView exportToExcel(HttpServletRequest request, HttpServletResponse response) throws Exception {
10
11 Map<String,Object> model=new HashMap<String,Object>();
12
13 Object[] datas;
14
15 datas = dataModel.getDatas.toArray();
16
17 model.put("data", datas);
18
19 ExcelView excelView = new ExcelView();
20
21 excelView.setApplicationContext(this.getWebApplicationContext());
22 excelView.setUrl("/WEB-INF/Template");
23
24 return new ModelAndView(excelView,model);
25 }
26 }
4. web.xml
1 <servlet>
2 <servlet-name>viewController</servlet-name>
3 <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
4 <init-param>
5 <param-name>contextConfigLocation</param-name>
6 <param-value>/WEB-INF/config/control-context.xml</param-value>
7 </init-param>
8 <load-on-startup>1</load-on-startup>
9 </servlet>
10 <servlet-mapping>
11 <servlet-name>viewController</servlet-name>
12 <url-pattern>*.report</url-pattern>
13 </servlet-mapping>
5. 运行
http://hostname/view/exportToExcel.report