SpringMvc+POI 处理Excel的导入操作需要的所有环境

jquery.form.js包在：http://plugins.jquery.com/form/
jquery.js自行下载

主代码请往：http://blog.csdn.net/onepersontz/article/details/49891405   进行查看，后面有自己修改的代码

本人用的是JDK8+spring4.28+tomcat8.0

以上是jar包

以上是结构

需要改的地方：第一处：

 

for (int j = sheet.getFirstRowNum(); j <sheet.getLastRowNum()+1; j++)    

 

第二处： 

 

 

 

for (int y = row.getFirstCellNum(); y < row.getLastCellNum(); y++) {
cell = row.getCell(y);
if(cell==null){
li.add("");
}else{

li.add(this.getCellValue(cell));}
}

 

第三处：处理数据类型的问题

 

 

case Cell.CELL_TYPE_NUMERIC: 
 if("m/d/yy".equals(cell.getCellStyle().getDataFormatString())){
value = sdf.format(cell.getDateCellValue());
}else{
HSSFDataFormatter dataFormatter = new HSSFDataFormatter(); 
      value = dataFormatter.formatCellValue(cell);
}

 

 

 

第四处：前后缀被我注解掉了

 

<!-- 视图解释类 -->  
     <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- <property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property> -->
</bean>

 

 

 

第五处：spring版本的头文件

 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" 
xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
xmlns:jee="http://www.springframework.org/schema/jee" 
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop" 
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:util="http://www.springframework.org/schema/util"
xmlns:jpa="http://www.springframework.org/schema/data/jpa"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.2.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.2.xsd">
</beans>

 

 

 

</beans>

第六处：防止可能的中文乱码

在web.xml中加

 

<filter> <filter-name>SetCharacterEncoding</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>SetCharacterEncoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>