JAVA WEB上传EXEL文档并作解析.docVIP

JAVA WEB上传EXEL文档并作解析 在javaweb中上传Exel本解析其中的文件的方法 1.jsp页面的内容:lt;formaction=servlet/AutoAddStudentsmethod=postenctype=multipart/form-datagt;lt;inputtype=filename=filenamegt;lt;br/gt; lt;inputtype=submitvalue=提交/gt;lt;/formgt; 2.Servlet处理过程 1注释中的内容是用程。个人感觉还是jxl解析方便一点。只不过org.apache.poi可以解析包括2.解析过程需要mons这个组件 packagecom.fan.servlet; importjava.io.File; importjava.io.IOException; importimportjava.util.List; import import import importjavax.servlet.ServletException;javax.servlet.http.HttpServlet;javax.servlet.http.HttpServletRequest;javax.servlet.http.HttpServletResponse; importjxl.Sheet; importjxl.Workbook; importjxl.read.biff.BiffException; importimport import importimport import import import import import mons.fileupload.FileItem;mons.fileupload.FileItemFactory;mons.fileupload.FileUploadException;mons.fileupload.disk.DiskFileItemFactory;mons.fileupload.servlet.ServletFileUpload; publicclassextendsHttpServlet privatestaticfinallongFILE_MAX_SIZE=4*1024*1024;publicvoiddoPost(HttpServletRequestHttpServletResponseresponse) throwsServletException,IOException{request, if(!ServletFileUpload.isMultipartContent(request)){ System.out.println(失败1);}StringfileTempPath= this.getServletContext().getRealPath(/)+filetemp;FiletempDir=newFile(fileTempPath); if(!tempDir.exists()){tempDir.mkdirs();}FileItemFactoryfactory=newDiskFileItemFactory(4096,tempDir); ServletFileUploadsfu=newServletFileUpload(factory);sfu.setFileSizeMax(FILE_MAX_SIZE); Listlt;FileItemgt;fileItems=null; //////try{fileItems=sfu.parseRequest(request);}catch(FileUploadExceptione){e.printStackTrace();if(eSizeLimitExceededException){} return;} if(fileItems==null||fileItems.size()==0){ System.out.println(失败2); return;}//HSSFWorkbookbook=newHSSFWorkbook(fileItems.get(0).getInputStream());//HSSFSheetsheet1=book.getSheetAt(0);//for(Rowrow:sheet1){//for(Cellcell:row){ //C