52,797
社区成员
发帖
与我相关
我的任务
分享
<div>
<form name="uploadForm" enctype="multipart/form-data" action="excel_in.action" >
Excel文件路径:
<input type="file" id="uploadFile" name="upload"><br>
<input class="submit" type="button" onclick="javascript:importEmp();" value="导入">
</form>
</div>
public class ExcelInAction {
private File upload ; //上传的文件
private String uploadFileName; //保存原始文件名
private String tip;
public Workbook createWorkBook(InputStream is) throws IOException{
if(uploadFileName.toLowerCase().endsWith("xls")){
return new HSSFWorkbook(is);
}else if(uploadFileName.toLowerCase().endsWith("xlsx")){
return new XSSFWorkbook(is);
}else{
return null;
}
}
public String execute() throws Exception{
Workbook book = createWorkBook(new FileInputStream(upload));
if(book == null){//防止跳过页面直接访问报错
tip = "请选择excel格式文件";
return "success";
}
Sheet sheet = book.getSheetAt(book.getActiveSheetIndex());
<!--excel in导入 -->
<action name="excel_in" class="com.menu.action.ExcelInAction">
<result name="success" >/PTUI/lxrglf/excel_in.jsp</result>
</action>
enctype="multipart/form-data" method="post"
<form enctype="multipart/form-data" method="post" /> form 标签必须有这个修饰