struts2 excel文件上传

最新推荐文章于 2021-02-16 09:21:57 发布

jbgtwang

最新推荐文章于 2021-02-16 09:21:57 发布

阅读量2.4k

点赞数

CC 4.0 BY-SA版权

文章标签： struts excel string file exception xhtml

本文链接：https://blog.youkuaiyun.com/jbgtwang/article/details/6894149

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<div>

</form>
<br />
</div>
</center>
</div>


</body>

</html>

struts.xml--------------------------

action--------------------------

private File uploadFile;
private String uploadFileFileName;

/**
   * @return the uploadFileFileName
   */
   public String getUploadFileFileName() {
       return uploadFileFileName;
   }

   /**
   * @param uploadFileFileName the uploadFileFileName to set
   */
   public void setUploadFileFileName(String uploadFileFileName) {
       this.uploadFileFileName = uploadFileFileName;
   }

   /**
   * @return the uploadFile
   */
   public File getUploadFile() {
       return uploadFile;
   }

   /**
   * @param uploadFile the uploadFile to set
   */
   public void setUploadFile(File uploadFile) {
       this.uploadFile = uploadFile;
   }

public String getUploadExcel() {

       try {

           InputStream in = new FileInputStream(uploadFile);//不用request.getInputStream();
            XSSFWorkbook xwb;

xwb = new XSSFWorkbook(in);

            // 读取第一章表格内容
           XSSFSheet sheet = xwb.getSheetAt(0);
           // 定义 row、cell
           XSSFRow row;
           int rows = sheet.getPhysicalNumberOfRows();
           System.out.println("有效行数=" + rows);

/////////////////////

///其他代码//

//////////////////////

       } catch (Exception e) {
           e.printStackTrace();

       }
       return null;
   }