注意:上传的excel文件的模板是否正确
jsp页面:
<s:form namespace="user" enctype="multipart/form-data">
<s:token name="user_excelcreate"/>
<div class="navigate_header">当前位置:excel导入</div>
<table class="table_frame" width="100%">
<thead>
<tr><th colspan="4">信息上传</th></tr>
</thead>
<tr>
<td><s:file label="上传" theme="simple" name="upload" id="upload"/></td>
<td><s:submit name="action:user_doExcelSwitch" value="上传"/></td>
</tr>
</table>
<font color="red">注:请确认上传文件的格式为excel文件,且后缀为.xls</font>
</s:form>
action:
public class User implements ServletRequestAware{
private SimpleDateFormat sdf ;
// 封装单个上传文件域的属性
private File upload;
// 封装单个上传文件名的属性
private String uploadFileName;
public String doExcelSwitch(){
List<User> userList = new ArrayList<User>();
sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String createtime = sdf.format(new Date());
//读取数据,放