Spring框架下读取客户端Excel文件

首先把文件上传至服务器,可以直接获得输入流。

1、需要在配置文件里加入：

<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    <property name="maxUploadSize">
        <value>204800000</value>
    </property>
</bean>

2、提交页面。注意要加上encType="multipart/form-data"

<form id="form1" name="form1" action="<c:url value='/login.do'/>" method="post" encType="multipart/form-data">
    <input type="file" name="file1"/>
    <input type="submit" value="提交"/>
</form>

3、控制器中：

protected ModelAndView handleRequestInternal(HttpServletRequest request, HttpServletResponse response) throws Exception {
    MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
    InputStream in = multipartRequest.getFile("file1").getInputStream();
}

4、处理Excel文件，我用到jxl.jar包http://sourceforge.net/project/showfiles.php?group_id=79926。可以用3中的in获得工作簿。

Workbook ws = Workbook.getWorkbook(in);