[SPRING] modelandview abstract 엑셀뷰 적용 방법

참조사이트
http://www.mkyong.com/spring-mvc/spring-mvc-export-data-to-excel-file-via-abstractexcelview/

1. APACHE POI 설정

   <!-- Excel library --> 
   <dependency>
 <groupId>org.apache.poi</groupId>
 <artifactId>poi</artifactId>
 <version>3.6</version>
   </dependency> 

2. XmlViewResolver for the Excel view. 


Markup

ㅇ<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>


File : spring-excel-views.xml


Markup

   <bean id="ExcelRevenueSummary"
    class="com.mkyong.common.view.ExcelRevenueReportView">
   </bean>
이렇게 한후 컨트롤 단에서 return new MoedelAndView("excelView", "exceldata", ModelMap)
이렇게 호출하면됨