struts2+ajaxSubmit+poi导入excel

form表单

<form id="upLoadForm"  style="margin-bottom:3"><input type="hidden" name="hasGrupRole" value="<s:property value='hasGrupRole'/>">    <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#a8c7ce" onkeypress="enterQuery()">       <tr>        <td class="table_head_td" align="center">上传：</td>         <td class="table_head_td" ><input id="excelFile" name="files" type="file"/></td>       </tr>       <tr>        <td class="table_head_td" align="center" colspan="2">        <input type="button" value="提交" accesskey="M"  title="ALT+M" class="btn0" onclick="submitExcel();"/>        </td>       </tr>    </table></form>

js

function submitExcel(){if(confirm('确定上传数据!')){    var excelFile = $("#excelFile").val();        if(excelFile=='') {            alert("请选择需上传的文件!");            return false;        }        if(excelFile.indexOf('.xls')==-1){            alert("文件格式不正确，请选择正确的Excel文件(后缀名.xls)！");            return false;        }$("#upLoadForm").ajaxSubmit({   type: "POST",  encType:'multipart/form-data',   url: '提交路径',   data:{'files':excelFile//  files action定义属性   File类型    },   success: function(data){   alert(data);//返回值});return false;//如不返回false会跳转页面}}

action

public void doUpload(){try{try {this.service.doUpLoad(model);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}finally{//Struts2Utils.getResponse().setContentType("text/xml;charset=utf-8");//返回值报错Struts2Utils.getResponse().setHeader("Content-type", "text/html;charset=UTF-8");//如不设置头信息会中文会出现火星文类型乱码Struts2Utils.getResponse().setCharacterEncoding("UTF-8"); //如不设置编码类型中文会出现‘？？？？？’乱码try {Struts2Utils.getResponse().getWriter().print(this.getModel().getMessage());//打印返回值传至前端} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

service

public void doUpLoad(TransCenterModel model) throws Exception{ // 检查后缀名是否符合条件,同时更改上传文件的文件名         int filesize = model.getFilesFileName().length();         String fileEx = model.getFilesFileName().substring(         model.getFilesFileName().indexOf("."), filesize);         //获取文件名 //        String fileName=model.getFilesFileName().substring(0,model.getFilesFileName().indexOf("."));         // 获得上传路径         String realPath = ServletActionContext.getServletContext().getRealPath(                 "/UploadFile/");         File saveFile=null;         ArrayList<ArrayList<String>> row=null;        if (model.getFiles() != null) {             saveFile = new File(new File(realPath), model.getFilesFileName());             if (!saveFile.getParentFile().exists()) {                 saveFile.getParentFile().mkdirs();             }              FileUtils.copyFile(model.getFiles(), saveFile);// 到这里，文件已上传成功            if (fileEx.equals(".xls") || fileEx.equals(".xlsx")) {             String files=saveFile.getPath();            String excel=files.substring(files.lastIndexOf("\\")).substring(1);            files=files.substring(0, files.lastIndexOf("\\"));            files=files.replaceAll("\\\\","\\\\\\\\");        row=readExcel(excel,files);            }<pre name="code" class="java"><span></span>    <span>for (ArrayList<String> cell : row) {        <span></span>/</span>/数据处理

<span></span>    ｝

}

        this.addMessages(model, "trans.upload.succ",new String[]{});}@SuppressWarnings("deprecation")public ArrayList<ArrayList<String>> readExcel(String fileName,String path) {           ArrayList<ArrayList<String>> Row =new ArrayList<ArrayList<String>>();                      try {           Workbook workBook = null;           try {                workBook = new XSSFWorkbook(path+"\\"+fileName);                } catch (Exception ex) {                workBook = new HSSFWorkbook(new FileInputStream(path+"\\"+fileName));                }                             for (int numSheet = 0; numSheet < workBook.getNumberOfSheets(); numSheet++) {                   Sheet sheet = workBook.getSheetAt(numSheet);                   if (sheet == null) {                       continue;                   }                   // 循环行Row                   for (int rowNum = 1; rowNum <= sheet.getLastRowNum(); rowNum++) {                       Row row = sheet.getRow(rowNum);                       if (row == null) {                           continue;                       }                       // 循环列Cell                       ArrayList<String> arrCell =new ArrayList<String>();                       for (int cellNum = 0; cellNum <= row.getLastCellNum(); cellNum++) {                           Cell cell = row.getCell(cellNum);                           if (cell == null) {                               continue;                           }                           arrCell.add(getValue(cell));                       }                       Row.add(arrCell);                   }              }           } catch (IOException e) {               System.out.println("e:"+e);           }                  return Row;       } private String getValue(Cell cell) {    cell.setCellType(Cell.CELL_TYPE_STRING); return cell.toString();  }